Database Administration (MOSC)

MOSC Banner

Turning off Auditing of SYS tables

edited Aug 4, 2017 5:03AM in Database Administration (MOSC) 10 commentsAnswered

Greetings all

I have created the following policy

CREATE AUDIT POLICY aud_action_phi

ACTIONS SELECT, UPDATE, DELETE, TRUNCATE TABLE, DROP TABLE

EVALUATE PER SESSION;

And enable it as such

AUDIT POLICY aud_action_phi by CIN_AUDIT, CIN_CDR_DOCREPOSITORY, CIN_CUSTOM, CIN_TACTICAL, SYS, SYSTEM;

I would like to audit ACTIONS SELECT, UPDATE, DELETE, TRUNCATE TABLE, DROP TABLE by users CIN_AUDIT, CIN_CDR_DOCREPOSITORY, CIN_CUSTOM, CIN_TACTICAL, SYS, SYSTEM

However my audit log is also capturing internal selects against SYS objects such as

DUAL

X$NLS_PARAMETERS

GV$NLS_PARAMETERS

V$NLS_PARAMETERS

NLS_SESSION_PARAMETERS

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