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';