Ensure that access to SYSIBM.SYSROUTINES is restricted

MoyenneNiveau 1Revue manuelledb2-zos

Description

The SYSIBM.SYSROUTINES table contains routines (user-defined function, cast function, or stored procedure). PUBLIC should be restricted from accessing this table. PUBLIC should not have access to routine definitions. Preventing PUBLIC to access routine information reduces the risk to your organization's data.

Méthode de vérification

Méthode d'audit: Revue manuelle

Cette recommandation ne peut pas être vérifiée automatiquement. Une analyse la liste avec ces instructions lorsque vous passez --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 = 'SYSROUTINES' 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.SYSROUTINES table in the MDSNTB class. Examine the universal access (UACC) and user ... (full steps: CIS section 2.2.21)

Méthode de correction

Méthode de correction: Recommandation ou correctif d'infrastructure

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

Propriétés

Systèmes d'exploitation: Tous
Étiquettes: db2-zospermissions
Référence: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.21 Ensure that access to SYSIBM.SYSROUTINES is restricted