4.2.2 Restrict Access to SYSCAT.AUDITUSE

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

The SYSCAT.AUDITUSE view contains database audit policy for all non-database objects, such as authority, groups, roles, and users. It is recommended that the PUBLIC role be restricted from accessing this view.

Rationale:

This view contains sensitive information about the types of objects being audited. Access to the audit policy may aid attackers in avoiding detection.

Solution

Revoke access from PUBLIC.

Connect to the Db2 database.

db2 => connect to <dbname>

Run the following command:

db2 => REVOKE SELECT ON SYSCAT.AUDITUSE FROM PUBLIC

See Also

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