RE: DBA Role Privs
- From: "Burton, Laura" <BurtonL@xxxxxxxxxxx>
- To: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 May 2006 07:19:02 -0500
Yes, you are correct about the granting. It is a little thing called
SOX.
________________________________
From: Hallas, John, Tech Dev [mailto:John.Hallas@xxxxxxxxxxxxxxxxx]
Sent: Monday, May 08, 2006 3:22 AM
To: Burton, Laura; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Burton, Laura
Sent: 05 May 2006 18:42
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
