Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBA Role Privs
Laura,
I know which is the underlying table but frankly creating triggers on SYS tables isn't something I would advise ... Except, perhaps, on SYS.AUD$. What about turning audit on, and putting a trigger on this one?
HTH STéphane Faroult
Burton, Laura wrote:
> 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-lReceived on Fri May 05 2006 - 13:14:46 CDT