Re: Role passwords

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 <jheinrichdba_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l