2 Replies Latest reply: Jun 24, 2014 8:21 AM by Galib Hussain RSS

    How do i find out who created the trigger

    933318

      Hi All,

       

      Some one has created a trgiier which is causing some issue in my Database , how can i find out who has done this.

       

      OWNER OBJECT_NAME OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME STATUS

      ---------- --------------------------- ---------- ------------------------- -------------------------- -------------------------- ---------------

      HP_XXXX WO25918_TRG 311950 TRIGGER 16_JUN_2014 13:24:09       16_JUN_2014 13:49:52       VALID


      SQL> show parameter audit

       

       

      NAME                                 TYPE                              VALUE

      ------------------------------------ --------------------------------- ------------------------------

      audit_sys_operations                 boolean                           TRUE

      audit_syslog_level                   string

      audit_trail                          string                            DB

       

      Please help.


      Thanks,