Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBA Role Privs
Ok, I received a couple of ideas and have tried both of them, but this
is my pick. However I am getting the following error when trying to
create the attached trigger:
Errors for TRIGGER CHECK4DBA_TGR:
LINE/COL ERROR
40/9 PLS-00103: Encountered the symbol "SEND_EMAIL" when expecting one
of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "SEND_EMAIL" to continue.
I did have EXECUTE in front of the procedure, but read where it should be a CALL. I thought , AHA, that's the problem....but received the same error. I can copy the EXECUTE procedure (now a CALL) line into SqlPlus and it works fine. It's just not working within the trigger. I read where you can execute a procedure from a trigger, but the example did not have it in a plsql block. Could this be the problem? I thought I read something about executing a procedure within a plsql block, but I have read so many different things today I'm having an information overload.
Any help, or direction, would be appreciated.
Thanks, Laura
From: Baumgartel, Paul [mailto:paul.baumgartel_at_credit-suisse.com]
Sent: Friday, May 05, 2006 12:54 PM
To: Burton, Laura; oracle-l_at_freelists.org
Subject: RE: DBA Role Privs
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 orrevoked 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.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 05 2006 - 16:18:06 CDT
- text/plain attachment: crTGRchk4dbarole.txt