AUDIT sql command question 2007-08-15 - By Alvaro Jose Fernandez
Back
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
|
|
