Database Security Products (MOSC)

MOSC Banner

How to revoke only the "Admin option" from a sysdba

edited Dec 1, 2009 7:00AM in Database Security Products (MOSC) 5 commentsAnswered ✓
 We are creating the sysdba accounts for all of us dba with our employee numbers so that the audit logs register our employee numbers.  I notice that the sysdba privileged has been granted but how to remove the "with admn option" from a sysdba?
What we want is, that only one sysdba from the Security Department will have the admin option, meaning he will be the only one in granting the sysdba role.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center