Ensure that access to SYSIBM.SYSROUTINESTEXT is restricted

OrtaDüzey 1Manuel incelemedb2-zos

Açıklama

The SYSIBM.SYSROUTINESTEXT table is an auxiliary table for the TEXT column of the SYSIBM.SYSROUTINES table and is required to hold the LOB data. PUBLIC should be restricted from accessing this table. PUBLIC should not have access to a table holding the LOB data. Exposing LOB data can enable attackers to gain access to your organization's data.

Nasıl denetlenir

Denetim yöntemi: Manuel inceleme

Bu öneri otomatik olarak denetlenemez. --include-manual parametresini verdiğinizde tarama bunu bu talimatlarla birlikte listeler.

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 = 'SYSROUTINESTEXT' 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.SYSROUTINESTEXT table in the MDSNTB class. Examine the universal access (UACC) ... (full steps: CIS section 2.2.22)

Nasıl düzeltilir

Düzeltme yöntemi: Kılavuz veya altyapı yaması

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

Özellikler

İşletim sistemleri: Herhangi biri
Etiketler: db2-zospermissions
Referans: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.22 Ensure that access to SYSIBM.SYSROUTINESTEXT is restricted