How do I manage audits in Oracle 11gR1
Hi all,
I just make a duplicated production database onto my test server, this is to perform testing on how do I disable object level audits on all my tables in the database. I tried to perform NOAUDIT but it didn't work. Below is the entry for each auditing views. All this are configured by the previous engineer & there's no documentation detailing the reason why those audits are enabled.
SQL> select * from DBA_STMT_AUDIT_OPTS;
USER_NAME PROXY_NAME AUDIT_OPTION SUCCESS FAILURE
------------------------------ ------------------------------ ---------------------------------------- ---------- ----------
CREATE USER BY ACCESS BY ACCESS
ALTER USER BY ACCESS BY ACCESS