Types of Auditing Supported
Oracle provides specific support for three types of auditing:
- Schema object auditing
Allows you to specify schema objects to be audited. Oracle will write an audit record based upon the schema object being accessed.
- SQL statement auditing
Allows you to specify SQL statements to be audited. Oracle will write an audit record based upon the fact that a user executed a specific SQL statement.
- System privilege auditing
Allows you to specify particular system privileges to be audited. Oracle will write an audit record based upon the fact that a user exercised a specific system privilege.
You’ll find more details on how to implement each of these three audit options, along with examples, later in this chapter.
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.