RE: DBA Role Privs
- From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- To: <BurtonL@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 May 2006 09:21:47 +0100
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:
