Security Guide > Security Guide > Implementing Security Auditing > Security Auditing > Security Audit Statements
Was this helpful?
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.
Last modified date: 11/09/2022