Unified Audit Policy Data Dictionary Views
You can query data dictionary and dynamic views to find detailed auditing information about custom unified audit policies. The following table lists these views.
Tip: To find error information about audit policies, check the trace files. The USER_DUMP_DEST initialization parameter sets the location of the trace files.
| View | Description |
|---|---|
ALL_AUDIT_POLICIES |
Displays information about all fine-grained audit policies |
ALL_DEF_AUDIT_OPTS |
Lists default object-auditing options that are to be applied when objects are created |
AUDIT_UNIFIED_CONTEXTS |
Describes application context values that have been configured to be captured in the audit trail |
AUDIT_UNIFIED_ENABLED_POLICIES |
Describes all unified audit policies that are enabled in the database |
AUDIT_UNIFIED_POLICIES |
Describes all unified audit policies created in the database |
AUDIT_UNIFIED_POLICY_COMMENTS |
Shows the description of each unified audit policy, if a description was entered for the unified audit policy using the COMMENT SQL statement |
AUDITABLE_SYSTEM_ACTIONS |
Maps the auditable system action numbers to the action names |
CDB_UNIFIED_AUDIT_TRAIL |
Similar to the UNIFIED_AUDIT_TRAIL view, displays the audit records but from all PDBs in a multitenant environment. This view is available only in the CDB root and must be queried from there. |
DBA_SA_AUDIT_OPTIONS |
Describes audited Oracle Label Security events performed by users, and indicates if the user’s action failed or succeeded |
DBA_XS_AUDIT_TRAIL |
Displays audit trail information related to Oracle Database Real Application Security |
DV$CONFIGURATION_AUDIT |
Displays configuration changes made by Oracle Database Vault administrators |
DV$ENFORCEMENT_AUDIT |
Displays user activities that are affected by Oracle Database Vault policies |
SYSTEM_PRIVILEGE_MAP (table) |
Describes privilege (auditing option) type codes. This table can be used to map privilege (auditing option) type numbers to type names. |
UNIFIED_AUDIT_TRAIL |
Displays all audit records |
Related Topics