Audit trail
The following views provide information about the status of auditing and audit trails:
- ALL_DEF_AUDIT_OPTS
Lists the default auditing options in effect for new objects.
- AUDIT_ACTIONS
Lists the audit codes and descriptions.
- *_AUDIT_EXISTS
Contains audit trail information generated by AUDIT EXISTS and AUDIT NOEXISTS.
- *_AUDIT_OBJECT
Contains audit trail information for object auditing.
- *_AUDIT_SESSION
Contains audit trail information for all connects and disconnects.
- *_AUDIT_STATEMENT
Contains audit trail information for all audited statements.
- *_AUDIT_TRAIL
Contains all audit trail information. The other _AUDIT_ views are subsets of this view.
- *_OBJ_AUDIT_OPTS
Lists all object auditing options in effect.
- *_PRIV_AUDIT_OPTS
Lists all system privilege auditing options in effect.
- STMT_AUDIT_OPTION_MAP
Lists the valid SQL statements that can be specified for statement auditing.
- *_STMT_AUDIT_OPTS
Lists all statement auditing options in effect.
- SYSTEM_PRIVILEGE_MAP
Lists the valid system privileges that can be specified for system privilege auditing.
- TABLE_PRIVILEGE_MAP
Lists the valid object audit options that can be specified for schema object auditing.