Re: Role passwords
Date: Mon, 4 Feb 2008 13:54:21 -0800
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-lReceived on Mon Feb 04 2008 - 15:54:21 CST