Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Auditing
Food wrote:
>
> hi all,
> I've got a database in AUDIT_TRAIL .....
> Exist a table or view where I can see the statements of a session ?
>
> For example :
> insert into table1
> select * from table2
> where field = '3';
Have a look at the chapter on auditing in the server doco, and also a look at $ORACLE_HOME/rdbms/admin/cataudit.sql
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Fri Mar 24 2000 - 00:00:00 CST
![]() |
![]() |