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 -> Capturing executed SQL statements using AUDIT command

Capturing executed SQL statements using AUDIT command

From: Forte Agent <1443131_at_usenetplanet.com>
Date: Wed, 23 Oct 2002 09:58:07 -0400
Message-ID: <pfadru4mcp23u0evp9g8a776c4db8nonad@4ax.com>

Is there some way to capture SQL statements users execute using Oracle's generic AUDIT command? SYS.AUD$ table has STATEMENT column, but I do not know how that is used. I tried something like this:

AUDIT SELECT ON xxx.yyyy BY ACCESS WHENEVER SUCCESSFUL;

Looking at DBA_AUDIT_STATEMENT did not reveal anything. What to do?? Thank you in advance. Received on Wed Oct 23 2002 - 08:58:07 CDT

Original text of this message

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