Unified auditing: Remove a privilege from ORA_SECURECONFIG
I have recently granted privilege EXEMPT ACCESS POLICY to some users.
I haven't noticed that this was creating AUDIT records. It ended filling up my SYSAUX tablespace.
I do not know how the new auditing works.
However I managed to find the below query:
SELECT *
FROM audit_unified_policies
WHERE policy_name in ('ORA_SECURECONFIG')
ORDER BY audit_option;
I see that the privilege EXEMPT ACCESS POLICY is being audited.
How can I stop or disable or remove the EXEMPT ACCESS POLICY from ORA_SECURECONFIG?
Thanks