Audit Insert Update Delete
430487Sep 14 2007 — edited Sep 17 2007I'm wondering if there's a way to track any/all SQL statements a user executes that are an insert/update/delete on any table in a schema.
Without turning on full auditing - I was hoping to create something "custom" to accomplish this. I was reading some of the documentation and found some information on "user event triggers" - but, I'm not sure if this is just a reference to regular before insert/update etc.. triggers on tables. Basically - if I can create a single procedure that captures all the insert/updates/deletes a user executes.
Any help/direction is appreciated.