Database Security Products (MOSC)

MOSC Banner

Unified Auditing & ORA-00942

edited Aug 31, 2018 5:04AM in Database Security Products (MOSC) 1 commentAnswered

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?

Tagged:

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