4 Replies Latest reply: Oct 13, 2012 3:55 AM by N_i_R_v_A_n_A RSS

    Trigger for logging changes(DML changes) for All tables in Schema

    N_i_R_v_A_n_A
      Hi ,

      Is there a way to create a schema level trigger to audit the DML changes that affect all the tables.I need the output in my log table as
      1) the table name on which the DML occurred
      2) type of DML
      3) column names affected.

      I know this can be achieved through enabling AUDIT or by creating dynamically, triggers for each tables...

      Is there a way to create a single trigger to achieve this??