Turning off Auditing of SYS tables
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