Have Geek Brain

Monitoring which statement is updating (and when) a specific row in a table since Oracle 10

I am using (should) a poorly designed Oracle database (10) for which I do not have admin rights (although I can create tables, triggers, etc. in my schema).

Now I have a problem: This DB is associated with multiple users / programs. I have to figure out who is updating a particular row, when and if possible: with which expression . Is it possible?

Thanks in advance!

0


a source to share


2 answers


It would be easier to do this if you had administrator rights to enable auditing. Without auditing authority, you are left with triggers to handle insert / update / delete logs. In your case, since you are only interested in updating, you can put a trigger on the table to run after the update, which logs in another table what was changed, by whom, from where, and until what day.



+2


a source


I would create a log table for the table you are working with. It will show you the type of operation and the oracle user ... as well as a bunch of other data if you need it.



0


a source






More articles:


All Articles