Oracle 19c Audit changes.

In Oracle 19c the following fields of AUDIT_UNIFIED_ENABLED_POLICIES table were renamed:

  • ENABLED_OPT renamed with ENABLED_OPTION
  • USER_NAME renamed with ENTITY_NAME

So the audit options query in Oracle 19c looks like this:

SELECT up.AUDIT_OPTION, uep.SUCCESS, uep.FAILURE from AUDIT_UNIFIED_ENABLED_POLICIES uep, AUDIT_UNIFIED_POLICIES up 
WHERE uep.ENTITY_NAME = 'ALL USERS' and uep.ENABLED_OPTION='BY USER' and uep.POLICY_NAME = up.POLICY_NAME and up.AUDIT_OPTION_TYPE = 'STANDARD ACTION';

and the value of ENABLED_OPTION column is now ‘BY USER’ but not ‘BY’ as in Oracle 18 and 12.

The query for listing all the fields:

SELECT column_name FROM user_tab_cols WHERE table_name = 'AUDIT_UNIFIED_ENABLED_POLICIES';
SELECT column_name FROM user_tab_cols WHERE table_name = 'AUDIT_UNIFIED_POLICIES';

Leave a Reply

Your email address will not be published.