RE: DBA Role Privs
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'BurtonL@xxxxxxxxxxx'" <BurtonL@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 5 May 2006 18:53:36 +0100
You need a DDL trigger, not a table trigger. Consult CREATE TRIGGER in the SQL
manual and search for "ddl_event".
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Burton, Laura
Sent: Friday, May 05, 2006 1:42 PM
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
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
Other related posts:
