RE: DBA Role Privs

Yes, you are correct about the granting. It is a little thing called SOX.  

From: Hallas, John, Tech Dev [mailto:John.Hallas_at_gb.vodafone.co.uk] Sent: Monday, May 08, 2006 3:22 AM
To: Burton, Laura; oracle-l_at_freelists.org Subject: RE: DBA Role Privs  

Others have pointed out the auditing functionality.

However who is granting DBA privileges if it is not you. I assume you are the DBA (or one of them) so why would other users have the authority/privileges to grant the DBA privileges.  

John  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Burton, Laura Sent: 05 May 2006 18:42
To: oracle-l_at_freelists.org
Subject: DBA Role Privs  

I want to be notified every time the DBA role is granted or revoked via email. I found the procedure which takes care of the email. Next I created a trigger on Insert into the Dba Role Privs view and received the error that this can not be performed on a view. Does anyone know the underlying Sys table(s) to use, or a better way of checking this?  

Thank you,

Laura

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