trigger to track dml on all tables on selecte schemas.
322074Apr 28 2009 — edited Apr 28 2009Hi All.
I'd like to create a trigger that records audit on a general table. The idea here is that everytime any user insert, delete or update any record on some selected schemas, a record must be inserted on this table. I don´t want to code a table trigger for every table on these schemas. Instead a global trigger, either for the database or at the schema level should fire.
Is this possible? i know there is for example a before or after ddl trigger. How can this be one for dml?
Regards, Luis ...!