Ensure that access to SYSIBM.SYSPLANAUTH is restricted

Trung bìnhCấp 1Xem xét thủ côngdb2-zos

Mô tả

The SYSIBM.SYSPLANAUTH table records the privileges that are held by users over application plans. PUBLIC should be restricted from accessing this table. The list of all users who have access to a plan should not be exposed to Public. Exposing this list can enable attackers to gain access to your organization's data.

Cách kiểm tra

Phương pháp kiểm tra: Xem xét thủ công

Khuyến nghị này không thể kiểm tra tự động. Lần quét sẽ liệt kê mục này kèm hướng dẫn khi bạn truyền cờ --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 = 'SYSPLANAUTH' 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.SYSPLANAUTH table in the MDSNTB class. Examine the universal access (UACC) and user ... (full steps: CIS section 2.2.16)

Cách khắc phục

Phương pháp khắc phục: Hướng dẫn hoặc bản vá hạ tầng

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

Thuộc tính

Hệ điều hành: Bất kỳ
Thẻ: db2-zospermissions
Tham chiếu: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.16 Ensure that access to SYSIBM.SYSPLANAUTH is restricted