Views containing audit trail information
- DBA_AUDIT_EXISTS
A subset of DBA_AUDIT_TRAIL containing information about actions referencing objects that do not exist
- DBA_AUDIT_OBJECT
A subset of DBA_AUDIT_TRAIL containing audit trail information specific to objects being audited
- DBA_AUDIT_SESSION
A subset of DBA_AUDIT_TRAIL containing auditing information about individual connections to the database
- DBA_AUDIT_STATEMENT
A subset of DBA_AUDIT_TRAIL containing auditing information about the use of specific audited SQL statements
- DBA_AUDIT_TRAIL
The full audit trail; contains all information included in all other audit trail views
- USER_AUDIT_OBJECT
A subset of USER_AUDIT_TRAIL containing audit trail information for the current user’s objects
- USER_AUDIT_SESSION
A subset of USER_AUDIT_TRAIL containing audit trail information about the current user’s connections to the database
- USER_AUDIT_STATEMENT
A subset of USER_AUDIT_TRAIL containing audit trail information about the current user’s use of audited SQL statements
- USER_AUDIT_TRAIL
A subset of DBA_AUDIT_TRAIL containing audit trail information for the current user
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access