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@xxxxxxxxx> 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