Database Administration (MOSC)

MOSC Banner

Oracle 11g Standard Audit : unable to remove audit of SELECT

Hi,

I have a database on Oracle 11.2.0.4 on Oracle Linux. Audit trail parameters are set as follow:
audit_sys_operations = FALSE
audit_trail = DB_EXTENDED

I removed au the audit rules so these queries return nothing:
SELECT * FROM DBA_STMT_AUDIT_OPTS;
SELECT * FROM DBA_PRIV_AUDIT_OPTS;
SELECT * FROM DBA_OBJ_AUDIT_OPTS;
SELECT * FROM DBA_AUDIT_POLICIES;

One more information: there's a logon trigger.
With this setting, the instance is auditing all the SELECT and that's where I do not understand.
Any suggestions?
Thanks

Christophe

Tagged:

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