Ensure that access to SYSIBM.SYSRESAUTH is restricted

中レベル 1手動レビューdb2-zos

説明

The SYSIBM.SYSRESAUTH table contains a list of all users that have various privileges on an object (collections, distinct types, etc.). PUBLIC should be restricted from accessing this table. PUBLIC should not have access to this list of users. Exposing who has access to resources can enable attackers to gain access 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 = 'SYSRESAUTH' 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.SYSRESAUTH table in the MDSNTB class. Examine the universal access (UACC) and user ... (full steps: CIS section 2.2.18)

修正方法

修正方法: ガイダンスまたは IaC パッチ

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