RE: DBA Role Privs

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Fri, 5 May 2006 18:53:36 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0BF94152@ENYC11P32005.corpny.csfb.com>

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_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Burton, Laura Sent: Friday, May 05, 2006 1:42 PM
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 05 2006 - 12:53:36 CDT