Ensure that access to SYSIBM.SYSCONTROLS is restricted

SedangLevel 1Tinjauan manualdb2-zos

Deskripsi

The SYSIBM.SYSCONTROLS table contains row permissions and column masks. PUBLIC should be restricted from accessing this table. This table contains sensitive information. No PUBLIC access should be allowed to reduce the risk to your organization's data.

Cara pemeriksaan

Metode audit: Tinjauan manual

Rekomendasi ini tidak dapat diperiksa secara otomatis. Pemindaian akan menampilkannya beserta petunjuk ini saat Anda memberikan opsi --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 = 'SYSCONTROLS' 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.SYSCONTROLS table in the MDSNTB class. Examine the universal access (UACC) and user ... (full steps: CIS section 2.2.6)

Cara perbaikan

Metode perbaikan: Panduan atau patch infrastruktur

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

Properti

Sistem operasi: Apa saja
Tag: db2-zospermissions
Referensi: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.6 Ensure that access to SYSIBM.SYSCONTROLS is restricted