Oracle7 Server Administrator's Guide
Creating and Deleting the Database Audit Trail Views
This section describes how to create and delete database audit trail views, and includes the following topics:
The database audit trail (SYS.AUD$) is a single table in each Oracle database's data dictionary. To help you view meaningful auditing information in this table, several predefined views are provided. They must be created for you to use auditing; you can later delete them if you decide not to use auditing.
See Also: On most operating systems, the audit trail views are created automatically with the data dictionary. See your operating system-specific Oracle documentation.
Creating the Audit Trail Views
If you decide to use auditing, create the auditing views by connecting as SYS and running the script CATAUDIT.SQL. This script creates the following views:
- USER_OBJ_AUDIT_OPTS, DBA_OBJ_AUDIT_OPTS
- USER_AUDIT_TRAIL, DBA_AUDIT_TRAIL
- USER_AUDIT_SESSION, DBA_AUDIT_SESSION
- USER_AUDIT_STATEMENT, DBA_AUDIT_STATEMENT
- USER_AUDIT_OBJECT, DBA_AUDIT_OBJECT
- USER_AUDIT_SESSION, DBA_AUDIT_SESSION
See Also: For information about these views, see the Oracle7 Server Reference.
For examples of audit information interpretations, see "Viewing Database Audit Trail Information" ![[*]](jump.gif)
.
Deleting the Audit Trail Views
If you disable auditing and no longer need the audit trail views, delete them by connecting to the database as SYS and running the script file CATNOAUD.SQL. The name and location of the CATNOAUD.SQL script are operating system-dependent.