Ensure that access to package-related tables is restricted

SrednjaNivo 1Ručni pregleddb2-zos

Opis

The following tables contain information related to packages, dependencies of packages on objects, and statements in the packages: SYSIBM.SYSPACKAGE SYSIBM.SYSPACKCOPY SYSIBM.SYSPACKDEP SYSIBM.SYSPACKLIST SYSIBM.SYSPACKSTMT SYSIBM.SYSPACKSTMT_STMB SYSIBM.SYSPACKSTMT_STMT PUBLIC should be restricted from accessing these tables.

Kako se proverava

Metod provere: Ručni pregled

Ova preporuka se ne može proveriti automatski. Skeniranje je navodi sa ovim uputstvima kada prosledite --include-manual.

For Db2 internal security users: Issue the following SQL statement to check if PUBLIC has access: SELECT GRANTEE, TCREATOR, TTNAME FROM SYSIBM.SYSTABAUTH WHERE TCREATOR = 'SYSIBM' AND TTNAME LIKE 'SYSPACK%' 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 profiles that control access to the package- related tables in the MDSNTB class. Examine the universal access ... (full steps: CIS section 2.2.12)

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

For Db2 internal security users: Issue the SQL REVOKE statement to revoke access from PUBLIC: For external security users: Issue the RACF RALTER command to update the profiles and change the UACC setting to NONE. Issue the RACF PERMIT command to remove the ID(*) and specify users or groups.

Svojstva

Operativni sistemi: Bilo koji
Oznake: db2-zospermissions
Referenca: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.12 Ensure that access to package-related tables is restricted