Restrict Access to SYSCAT.COLDIST

СреднийУровень 1Автоматическаяdb2

Описание

The SYSCAT.COLDIST view contains the nth most frequent value of some column, or the nth quantile (cumulative distribution) value of the column. It is recommended that the PUBLIC role be restricted from accessing this view. Counts grants to PUBLIC on SYSCAT.COLDIST (SYSCAT.TABAUTH); 0 is required. Database-level check: set DB2DBDFT to the database name to audit (the rule connects to it with the instance owner's credentials and fails when DB2DBDFT is unset). Run as the instance owner (or with sqllib/db2profile sourced) so the db2 CLP reads this instance's configuration.

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

Метод проверки: SQL-запрос

sql_query

db="${DB2DBDFT:?set DB2DBDFT to the database to audit}"; db2 connect to "$db" >/dev/null || exit 1; db2 -x "select count(*) from syscat.tabauth where tabschema = 'SYSCAT' and tabname = 'COLDIST' and grantee = 'PUBLIC'"; rc=$?; db2 connect reset >/dev/null 2>&1; db2 terminate >/dev/null 2>&1; exit $rc

Ожидаемый вывод: 0

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

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

Perform the following to revoke access from PUBLIC. 1. Connect to the Db2 database. db2 => connect to <dbname> 2. Run the following command: db2 => REVOKE SELECT ON SYSCAT.COLDIST FROM PUBLIC

Свойства

Операционные системы: Любая
Теги: db2databaseprivilegescatalog
Источник: CIS IBM Db2 12.1 Benchmark v1.0.0 - 4.2.4 Restrict Access to SYSCAT.COLDIST

Проверить этот хост

Выполните команду на компьютере, аудит которого вам разрешён. Сканирование работает только на чтение.

shell

tmaegis scan --target db2