Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to audit trigger enabling/disabling

How to audit trigger enabling/disabling

From: SL <sebastien-louchart_at_wanadoo.fr>
Date: 5 Sep 2006 00:47:44 -0700
Message-ID: <1157442464.368079.284640@i3g2000cwc.googlegroups.com>


Hello,

(8.1.7.4 on SUN Solaris 8, know it's a bit old but that's not the point
;)

This is a question about how to use the AUDIT statement to keep track of the enabling/disabling of triggers.

I set the AUDIT_TRAIL to TRUE and issue the following statement (logged as SYSDBA) :
AUDIT TRIGGER BY ACCESS; Then, I issued this statement :
alter trigger <owner>.<trigger> disable;

When I check the sys.aud$ table, I can't see any audit row for that statement.
(On the other side, I have some tables audited by access for delete,
insert and update statements. These statements log audit when issued)

I'm a bit confused with the AUDIT syntax and I surely forgot something. Thank you in advance for any help you can provide.

Cheers

-- 
SL
Received on Tue Sep 05 2006 - 02:47:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US