TMA-DB2-4.2.7

Restrict Access to SYSCAT.CONTEXTATTRIBUTES

MediaNivel 1Automatizadadb2

Descripción

The SYSCAT.CONTEXTATTRIBUTES view contains all the trusted context attributes in the database instance. It is recommended that the PUBLIC role be restricted from accessing this view. Counts grants to PUBLIC on SYSCAT.CONTEXTATTRIBUTES (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.

Cómo se verifica

Método de auditoría: Consulta 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 = 'CONTEXTATTRIBUTES' and grantee = 'PUBLIC'"; rc=$?; db2 connect reset >/dev/null 2>&1; db2 terminate >/dev/null 2>&1; exit $rc

Salida esperada: 0

Cómo se corrige

Método de corrección: Guía o parche de infraestructura

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.CONTEXTATTRIBUTES FROM PUBLIC

Propiedades

Sistemas operativos: Cualquiera
Etiquetas: db2databaseprivilegescatalog
Referencia: CIS IBM Db2 12.1 Benchmark v1.0.0 - 4.2.7 Restrict Access to SYSCAT.CONTEXTATTRIBUTES

Verificar este host

Ejecute esto en un equipo que tenga permiso para auditar. El escaneo es de solo lectura.

shell

tmaegis scan --target db2