Oracle7 Server Concepts
Statement Auditing
Statement auditing is the selective auditing of related groups of statements that fall into two categories:
- DDL statements, regarding a particular type of database structure or object, but not a specifically named structure or object (for example, AUDIT TABLE audits all CREATE and DROP TABLE statements)
- DML statements, regarding a particular type of database structure or object, but not a specifically named structure or object (for example, AUDIT SELECT TABLE audits all SELECT
. . . FROM TABLE/VIEW/SNAPSHOT statements, regardless of the table, view, or snapshot)
Statement auditing can be broad and audit the activities of all database users, or focused and audit only the activities of a select list of database users.