Skip to content
Log In

DB2 must generate audit records when successful accesses to objects occur.

An XCCDF Rule

Description

Without tracking all or selected types of access to all or selected objects (tables, views, procedures, functions, etc.), it would be difficult to establish, correlate, and investigate the events relating to an incident, or identify those responsible for one. In an SQL environment, types of access include, but are not necessarily limited to: SELECT INSERT UPDATE DELETE EXECUTE

ID
SV-213759r879878_rule
Version
DB2X-00-012000
Severity
Medium
References
Updated

Remediation Templates

A Manual Procedure

Run the following command to define an audit policy with the needed subset using the CREATE AUDIT POLICY SQL statement: 
DB2> CREATE AUDIT POLICY <execdb> 
           CATEGORIES CONTEXT STATUS BOTH, EXECUTE STATUS BOTH 
           ERROR TYPE AUDIT

To modify an existing audit policy, replace "CREATE" with "ALTER" in the preceding statement. Only the categories explicitly named in the statement will be affected.  In this case, the changes take effect immediately.