Re: Role passwords

From: Jared Still <>
Date: Mon, 4 Feb 2008 13:54:21 -0800
Message-ID: <>

That may have an adverse effect on automated scripts and dba_jobs and dba_scheduled jobs that are dependent on the DBA role.

On Feb 4, 2008 1:06 PM, Jason Heinrich <> wrote:

> According to the documentation, role passwords are designed to prevent
> users from directly accessing application data without going through the
> application interface. Has anyone used them on human-oriented roles, such
> as DBA? We have a requirement to protect all "critical" roles with
> passwords, but given their shortcomings (no password management through
> profiles, multiple people may need to know the password, etc.), it seems to
> me that they would be more of a hinderance than a help. Thoughts?
> --
> Jason Heinrich

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Mon Feb 04 2008 - 15:54:21 CST

Original text of this message