Re: Auditing question in Oracle 8i

Nope. You can't see the statements, nor the values they returned/updated/deleted using this sort of auditing.

You do, however, have access to Log Miner... wherein all DML (but no selects, unfortunately) are laid as bare as bare can be.

Were you to upgrade to 9i, fine-grained auditing would allow you to see the text of select statements, too.

Regards
HJR "Troy Meyerink" <meyerink_at_usgs.gov> wrote in message news:Guq4tC.8zq_at_igsrsparc2.er.usgs.gov...
> I am currently implementing auditing in Oracle 8i. I am testing by adding
> select, update, and delete by access auditing on a couple of tables. In
the
> dba_audit_trail there is a column called the statementid. I was hoping I
> could actually look at the statement that performed the audit action. Is
> there any way to do this? I looked for statementid field in the
> dba_tab_columns and only found tables with the reference number and no
> correlating statement text. Thank you for your help.
>
> Troy Meyerink
> Oracle DBA
> Raytheon
> EROS Data Center
> Sioux Falls, SD
>
>
Received on Wed Apr 17 2002 - 23:39:06 CDT