Secure CONNECT Authority

MediaNivel 1Revisión manualdb2

Descripción

The CONNECT role grants the authority to a user to connect to mainframe and midrange databases from Windows, Unix, and Linux operating systems. It is recommended that the CONNECT role be granted to authorized users only.

Cómo se verifica

Método de auditoría: Revisión manual

Esta recomendación no se puede verificar automáticamente. Un escaneo la lista con estas instrucciones cuando se pasa --include-manual.

1. Connect to the Db2 database. db2 => connect to <dbname> 2. Run the following command: db2 => select distinct grantee, granteetype from syscat.dbauth where connectauth = 'Y' 3. Review the list of users, groups, and roles in the above output to ensure only approved users, groups, and roles are assigned.

Cómo se corrige

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

Revoke this permission from any unauthorized users. 1. Connect to the Db2 database. db2 => connect to <dbname> 2. Run the following command: db2 => REVOKE CONNECT ON DATABASE FROM USER <username>

Propiedades

Sistemas operativos: Cualquiera
Etiquetas: db2databasemanual
Referencia: CIS IBM Db2 12.1 Benchmark v1.0.0 - 6.1.13 Secure CONNECT Authority