Re: auditing table help

From: Pavel <ocp.pauler_at_gmail.com>
Date: Wed, 2 Mar 2011 15:08:44 +0300
Message-ID: <AANLkTikCSHfGSJknLdX3Nc-nVHgo8CPxJOZMHZS1zGkV_at_mail.gmail.com>

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."
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 02 2011 - 06:08:44 CST