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-l