Ensure that access to SYSIBM.SYSSTMT is restricted

中级别 1人工审核db2-zos

说明

The SYSIBM.SYSSTMT table contains all SQL statements for each DBRM. PUBLIC should be restricted from accessing this table. PUBLIC should not have access to these SQL statements. Preventing PUBLIC to access sensitive information reduces risk to your organization's data.

检查方式

审计方法: 人工审核

此项建议无法自动检查。当您传入 --include-manual 时，扫描结果会列出该项并附带这些说明。

For Db2 internal security users: Issue the following SQL statement to check if PUBLIC has access: SELECT GRANTEE FROM SYSIBM.SYSTABAUTH WHERE TCREATOR = 'SYSIBM' AND TTNAME = 'SYSSTMT' AND GRANTEE = 'PUBLIC'; Output that contains zero rows is considered a successful finding. Otherwise, PUBLIC has SELECT privilege and the remediation steps should be followed. For external security users: Issue the RACF RLIST command to list the profile that controls access to the SYSIBM.SYSSTMT table in the MDSNTB class. Examine the universal access (UACC) and user (USER) ... (full steps: CIS section 2.2.26)

修复方式

修复方法: 操作指南或基础设施补丁

For Db2 internal security users: Issue the following SQL statement to revoke access from PUBLIC: REVOKE ALL ON SYSIBM.SYSSTMT FROM PUBLIC; For external security users: Issue the RACF RALTER command to update the profile and change the UACC setting to NONE. Issue the RACF PERMIT command to remove the ID(*) and specify users or groups.

属性

操作系统: 任意
标签: db2-zospermissions
参考: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.26 Ensure that access to SYSIBM.SYSSTMT is restricted