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
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.