RE: AUDIT sql command question

Lyndon,
are you commiting the updates?

Jaust to check: in the same UPDATE session, before the updates, do an

alter session set events '10046 trace name context forever, level 8'; (to trace all ops )

Do the updates, finish the session, and then see the tracefile generated, and look for entries regarding sys.aud$ .

         "To audit occurrences of a SQL statement, you must have AUDIT SYSTEM system privilege."

--
   

If I did not have audit any priv, would this sql have failed?

audit update table;

I ran this command successfully:

SQL> audit update table;

Audit succeeded.

--

Lyndon Tiu
--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 15 2007 - 08:25:40 CDT