Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Audit Insert Update Delete

430487Sep 14 2007 — edited Sep 17 2007
I'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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2007
Added on Sep 14 2007
10 comments
2,542 views