Chapter 7. Auditing

Once the database is operational, you will want to track various types of activity within the database. This tracking is called auditing. Using the AUDIT SQL statement, you can track access to individual objects, use of specific SQL statements, or the exercise of any of the system privileges.

Don’t confuse auditing with monitoring the database. While auditing lets you see what is happening at a logical level, monitoring lets you see what is going on physically within the instance. Monitoring, described briefly in Chapter 6, is primarily designed to support tuning.

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.