Ensure that access to SYSIBM.SYSDBAUTH is restricted

СреднийУровень 1Ручная проверкаdb2-zos

Описание

The SYSIBM.SYSDBAUTH table records the privileges that are held by users over databases. PUBLIC should be restricted from accessing this table. This table contains all the grants over databases and may be used as an attack vector. Exposing who has access to databases can enable attackers to gain access to databases.

Как проверяется

Метод проверки: Ручная проверка

Эту рекомендацию нельзя проверить автоматически. Сканирование выводит её вместе с этими инструкциями при указании флага --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 = 'SYSDBAUTH' 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.SYSDBAUTH table in the MDSNTB class. Examine the universal access (UACC) and user ... (full steps: CIS section 2.2.8)

Как исправляется

Метод исправления: Рекомендация или патч инфраструктуры

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

Свойства

Операционные системы: Любая
Теги: db2-zospermissions
Источник: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.8 Ensure that access to SYSIBM.SYSDBAUTH is restricted