Security Audit Statements
Levels of security auditing are enabled and disabled with the SQL statements ENABLE SECURITY_AUDIT and DISABLE SECURITY_AUDIT.
To use these statements, you must have the maintain_audit privilege and be connected to the iidbdb database.
Keywords on these statements allow you to specify the types of security events you want to audit. For example:
• DATABASE--to control logging of database access
• PROCEDURE--to control logging of procedure access
• ALL--to control logging of all possible security events
The events specified using these statements are known as the default events, which is a term that applies when specifying auditing levels for users, profiles, and roles, as described in the next section.