Ensure that access to SYSIBM.SYSQUERY is restricted

MittelStufe 1Manuelle Prüfungdb2-zos

Beschreibung

The SYSIBM.SYSQUERY table identifies an SQL statement. PUBLIC should be restricted from accessing this table. PUBLIC should not have access to the SQL statement information. Exposing SQL statement information can enable attackers to gain access to your organization's data.

So wird geprüft

Prüfmethode: Manuelle Prüfung

Diese Empfehlung kann nicht automatisch geprüft werden. Ein Scan führt sie mit diesen Anweisungen auf, wenn Sie --include-manual übergeben.

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= 'SYSQUERY' 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.SYSQUERY table in the MDSNTB class. Examine the universal access (UACC) and user (USER) ... (full steps: CIS section 2.2.17)

So wird behoben

Behebungsmethode: Anleitung oder Infrastruktur-Patch

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

Eigenschaften

Betriebssysteme: Beliebig
Tags: db2-zospermissions
Referenz: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.17 Ensure that access to SYSIBM.SYSQUERY is restricted