Views containing auditing specifications
- ALL_DEF_AUDIT_OPTS
Lists the current default schema object auditing levels for schema objects that may be created in the future
- DBA_OBJ_AUDIT_OPTS
Lists the current object auditing levels for every object in the database
- DBA_PRIV_AUDIT_OPTS
Lists the current system privileges being audited; if auditing is turned on for a particular user, that information is also included in this view
- DBA_STMT_AUDIT_OPTS
Lists the current SQL statements being audited; if auditing is turned on for a particular user, that information is also included in this view
- USER_OBJ_AUDIT_OPTS
A subset of DBA_OBJ_AUDIT_OPTS that shows object auditing levels for objects owned by 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.