'oracle, How to exclude certain table from unified Audit policy
I have Oracle 12.2.0.1 unified audit policy for developers:
CREATE AUDIT POLICY dev_dml_audit_policy
ACTIONS DELETE, INSERT, UPDATE
WHEN 'SYS_CONTEXT(''USERENV'', ''SESSION_USER'') in (''DEV1'',''DEV2'',''DEV3'') '
EVALUATE PER statement;
This police auditing all DML for all tables in database for users: 'DEV1','DEV2','DEV3' .
I need exclude from auditing certain tables, for example: user1.table1, user2.table2
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|