Ensure that access to SYSIBM.SYSPARMS is restricted

中等級 1人工審核db2-zos

說明

The SYSIBM.SYSPARMS table contains a row for each parameter of a routine or multiple rows for table parameters (one for each column of the table). PUBLIC should be restricted from accessing this table. Routine or table parameters should not be exposed to PUBLIC. Exposing routine or table parameters can enable attackers to gain access to 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 = 'SYSPARMS' 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.SYSPARMS table in the MDSNTB class. Examine the universal access (UACC) and user (USER) ... (full steps: CIS section 2.2.14)

修補方式

修補方法: 操作指南或基礎設施修補檔

For Db2 internal security users: Issue the following SQL statement to revoke access from PUBLIC: REVOKE ALL ON SYSIBM.SYSPARMS 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.14 Ensure that access to SYSIBM.SYSPARMS is restricted