Unified Auditing & ORA-00942
Let me start out by saying that I have Pure Unified Auditing enabled: I have relinked my Oracle executable and restarted my database. DBA_AUDIT_TRAIL is dead, long live UNIFIED_AUDIT_TRAIL.
Prior to Unified Auditing there is ability to:
AUDIT DOES NOT EXIST
I have not found where Unified Auditing has the equivalent feature.
I have tried:
CREATE AUDIT POLICY FAILED_DML ACTIONS SELECT, INSERT, UPDATE, DELETE
AUDIT POLICY FAILED_DML WHENEVER NOT SUCCESSFUL
This Audit Policy does not seem to catch ORA-00942 return codes. I have only seen it catch non-user facing/Oracle-internal return codes (10980, 2004).
Has anyone else seen this behavior or found a work around?