Someone is updating a record in a custom Oracle table, is there a way to find who is updating the record and or at least the table?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Aug 29 '12 at 4:02
This question came from our site for professional and enthusiast programmers.
You can audit updates to the table (assuming that auditing is enabled in your database). Or you can create a trigger on the table that captures the user and the row being updated and writes the results to an audit table. Or you can use the
In any of these cases, you'll see the Oracle user that did the