Re: Auditing SQL statements

In article <9v20v4$oeq$1_at_news1.xs4all.nl>, "Tony" says...
>
>Hi,
>
>I have enables auditing on Oracle 806. In sys.aud$, i see the audited info i
>need, EXCEPT:
>
>I want to know which sql-statement has been fired: There is an statementID
>in sys.aud$, but WHERE can I find the sql-statement being referred to??????
>
>oracle documentation is not very clear about that......
>
>Tony
>
>

the audit trail does not capture the statement itself, only the statement TYPE -- insert/update/delete/select.

In Oracle9i, there is fine grained auditing which does capture the actual statement, bind variable values and the SCN in place at the time of the audit (allowing you to "flashback" and see what they saw)

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp