Re: auditing table help

Hi
What is value for parameter audit_trail? Check with
audit_trail='db,extended'.

Best regards,
Pavel.

2011/3/2 Sreejith S Nair <Sreejith.Sreekantan_at_ibsplc.com>

> You can check FGA which is pretty simple to configure and efficient.>>>> Cheers> Sreejith Nair>>>>> From: "Alessandro Lia" <a.lia_at_tct-it.com>> To: <Oracle-L_at_FreeLists.org>> Date: 03/02/2011 03:04 PM> Subject: auditing table help> Sent by: oracle-l-bounce_at_freelists.org> ------------------------------>>>> 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>>>>>>> DISCLAIMER:>> "The information in this e-mail and any attachment is intended only for the> person to whom it is addressed and may contain confidential and/or> privileged material. If you have received this e-mail in error, kindly> contact the sender and destroy all copies of the original communication. IBS> makes no warranty, express or implied, nor guarantees the accuracy, adequacy> or completeness of the information contained in this email or any attachment> and is not liable for any errors, defects, omissions, viruses or for> resultant loss or damage, if any, direct or indirect.">>>>>