Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Capturing executed SQL statements using AUDIT command
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