4. Implementing Security Auditing : Security Auditing : Security Audit Statements
 
Share this page                  
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.