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@xxxxxxxxxx>

> You can check FGA which is pretty simple to configure and efficient.
>
>
>
> Cheers
> Sreejith Nair
>
>
>
>
> From:        "Alessandro Lia" <a.lia@xxxxxxxxxx>
> To:        <Oracle-L@xxxxxxxxxxxxx>
> Date:        03/02/2011 03:04 PM
> Subject:        auditing table help
> Sent by:        oracle-l-bounce@xxxxxxxxxxxxx
> ------------------------------
>
>
>
> 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."
>
>
>
>
>

Other related posts: