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??
It's not possible to create DML trigger on schema level
I think the only way is to create the triggers dynamically for each table.. Re: Schema level Database triggers by Kamran Agayev
Edited by: jeneesh on Oct 12, 2012 6:39 PM