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

Re: Capturing executed SQL statements using AUDIT command

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 25 Oct 2002 17:27:35 -0700
Message-ID: <130ba93a.0210251627.7967506f@posting.google.com>


This name DBA_AUDIT_STATEMENT is a bit misleading. It "lists audit trail records concerning GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements". If you audit on the system grant and issue something like "GRANT DBA to scott", it will be recorded in this view. Yours is an object grant and you want to look up DBA_AUDIT_TRAIL for auditing records.

Forte Agent <1443131_at_usenetplanet.com> wrote in message news:<pfadru4mcp23u0evp9g8a776c4db8nonad_at_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 Fri Oct 25 2002 - 19:27:35 CDT

Original text of this message

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