Re: checking trigger status

>How do I check whether a given trigger is enabled or disabled (is this
>status in a data dictionary view)?

Hi,

Try this :-

SQL> select owner,trigger_name,status
  2 from dba_triggers;

OWNER                          TRIGGER_NAME                   STATUS
------------------------------ ------------------------------ --------
SYSTEM                         DEF$_PROPAGATOR_TRIG           ENABLED
SYSTEM                         REPCATLOGTRIG                  ENABLED
MDSYS                          SDO_GEOM_TRIG_DEL1             ENABLED
MDSYS                          SDO_GEOM_TRIG_INS1             ENABLED
MDSYS                          SDO_GEOM_TRIG_UPD1             ENABLED
MDSYS                          SDO_LRS_TRIG_DEL               ENABLED
MDSYS                          SDO_LRS_TRIG_INS               ENABLED

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.