Oracle provides specific support for three types of auditing:
Allows you to specify schema objects to be audited. Oracle will write an audit record based upon the schema object being accessed.
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.
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.