Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Auditing

Re: Auditing

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/03/24
Message-ID: <38DB4C5A.FCB@yahoo.com>#1/1

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 worse
Received on Fri Mar 24 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US