Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center