4.2.1 Restrict Access to SYSCAT.AUDITPOLICIES

Information

The SYSCAT.AUDITPOLICIES view contains all audit policies for a database. It is recommended that the PUBLIC role be restricted from accessing this view.

Rationale:

This view contains sensitive information about the auditing security for this database. Access to the audit policies may aid attackers in avoiding detection.

Solution

Perform the following to revoke access from PUBLIC.

Connect to the Db2 database.

db2 => connect to <dbname>

Run the following command:

db2 => REVOKE SELECT ON SYSCAT.AUDITPOLICIES FROM PUBLIC

See Also

https://workbench.cisecurity.org/files/4033