auditing table help
- From: "Alessandro Lia" <a.lia@xxxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 2 Mar 2011 10:36:41 +0100
Dear list,
I need to trace which statement run on one table. I just need to know i.e.
"select etc...."
My DB parameter are set for auditing.
I run the following script :
audit select on "user.table_name" by session;
If I query the AUD$ table I get:
SESSIONID ENTRYID STATEMENT TIMESTAMP USERID
3355750 1 24 01-MAR-11 XXXXX
but I'm not able to find the statement executed.
Is there any way to get it? Is there any V$table to join to retrieve such info?
thank you for your collaboration
Alessandro
Other related posts:
