7.1.3 Ensure Audit Policies are Enabled Within the Database

Information

Creating and applying audit policies is crucial for securing and discovering issues within your databases.

Audit policies can help trigger events for changes to data objects, table DML, and user access.

Rationale:

If audit policies are not enabled, issues may go undiscovered, and compromises and other incidents may occur without being quickly detected. It may also not be possible to provide evidence of compliance with security laws, regulations, and other requirements.

Impact:

Auditing all categories within the database can have an impact on the peformance of the database server depending on the workload and number of transactions. If enabling audit as part of the remedation, analysis should be performed on which categories are required to meet business needs.

Solution

Connect to the Db2 database.

db2 => connect to <dbname>

Issue the following command to create an audit policy. This policy audits all categories. An analysis should be performed to determine which categories are required to meet business needs.

db2 => create audit policy AUDITDB CATEGORIES ALL STATUS BOTH ERROR TYPE AUDIT

Audit the database using the policy just created with the following command:

db2 => audit database using policy AUDITDB

See Also

https://workbench.cisecurity.org/benchmarks/10752

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-2, 800-53|AU-7, 800-53|AU-12, CSCv7|6.2

Plugin: IBM_DB2DB

Control ID: ed7cc5cd42dae9adccac1a8de8fef721bc5d7586eb8dfc81dd709313a0b78edb