RE: Audit statement

SELECT user_name, timestamp,
 obj_name,action_name
FROM dba_audit_trail
ORDER BY user_name;

action_name would give u the statement
dba_audit_trail is a view made up of aud$ and few other tables.

-Mandar

> -----Original Message-----
> From: Aldi Barco [mailto:ipal_at_hotmail.com]
> Sent: Monday, March 19, 2001 4:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Audit statement
>
>
> Hi Fellows,
>
> I would like to know who changed (DML statement) a record.
> (for example I wanti to know who changed the salary of Blake
> in emp table,
> not just who changed the salary in emp table).
> So, I want to audit : what statements were executed and by who.
> I have set 'audit_trail=db' in init.ora.
> I can find 'by who' from 'terminal' field in aud$ table.
> Where I can find 'what statements' ?
>
> Thanks in advance.
>
> Aldi
>
> ______________________________________________________________
> ___________
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Aldi Barco
> INET: ipal_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  INET: MandarG_at_gsr-inc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).