Re: Obtain SQL Statement from audit
Hi Mauricio, You cannot get the SQL statement for a select statement from the normal audit trail. If you have 9i then you can use Fine Grained Audit (FGA) to do this. There are some papers on normal audit on my site and also some stuff on FGA if you are interested. See my site at http://www.petefinnigan.com/orasec.htm hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Obtain SQL Statement from audit
Hi The version is Oracle 8i, so is there a way to retrieve the sql statement? could the v$sql view or v$sqltext view be useful? regards Arup Nanda [EMAIL PROTECTED] wrote: You haven't specified the Oracle version. If it's 9i, you could use Fine Grained Auditing (FGA) to get the exact SQLs. Hope this helps. Arup - Original Message - From: Mauricio Vélez To: Multiple recipients of list ORACLE-L Sent: Monday, December 29, 2003 1:39 PM Subject: Obtain SQL Statement from audit Hello everybody I am auditing select statements on one table, so I put the initialization parameter audit_trail = DB and I query the dba_audit_trail and sys.aud$ views and I can get information but I can't get the sql statement. The question is how can I retrieve the sql statement used to select on my table? Regards, Mauricio Vélez Do you Yahoo!?Yahoo! Photos - Get your photo on the big screen in Times Square Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003
Re: Obtain SQL Statement from audit
You haven't specified the Oracle version. If it's 9i, you could use Fine Grained Auditing (FGA) to get the exact SQLs. Hope this helps. Arup - Original Message - From: Mauricio Vélez To: Multiple recipients of list ORACLE-L Sent: Monday, December 29, 2003 1:39 PM Subject: Obtain SQL Statement from audit Hello everybody I am auditing select statements on one table, so I put the initialization parameter audit_trail = DB and I query the dba_audit_trail and sys.aud$ views and I can get information but I can't get the sql statement. The question is how can I retrieve the sql statement used to select on my table? Regards, Mauricio Vélez Do you Yahoo!?Yahoo! Photos - Get your photo on the big screen in Times Square