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

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

Re: Auditing

From: <devdev_at_my-deja.com>
Date: 2000/03/24
Message-ID: <8bgij2$fsu$1@nnrp1.deja.com>#1/1

Nop. You sql is not recorded, however you can audit table access, and statement types, or you can use available monitoring tools to watch for active sessions and capture their sql. I am using a tool called dbTools for both sorts of tasks mentioned above. It also includes a GUI tool for the auditing, kinda of click, click, click, you don't have to remember sql syntax and oracle table names. http://www.softtreetech.com/monitor Regards,
Dev
In article <8bfule$40a$1_at_pegasus.tiscalinet.it>, "Food" <Food_at_flashnet.it> 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';
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 24 2000 - 00:00:00 CST

Original text of this message

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