Ensure that access to SYSIBM.SYSSEQUENCES is restricted

MédiaNível 1Revisão manualdb2-zos

Descrição

The SYSIBM.SYSSEQUENCES table contains sequence definition. PUBLIC should be restricted from accessing this table. PUBLIC should not have access to sequence information. Exposing sequence information can enable attackers to gain access to your organization's data.

Como é verificado

Método de auditoria: Revisão manual

Esta recomendação não pode ser verificada automaticamente. Uma varredura a lista com estas instruções quando você passa --include-manual.

For Db2 internal security users: Issue the following SQL statement to check if PUBLIC has access: SELECT GRANTEE FROM SYSIBM.SYSTABAUTH WHERETCREATOR = 'SYSIBM' AND TTNAME = 'SYSSEQUENCES' 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.SYSSEQUENCES table in the MDSNTB class. Examine the universal access (UACC) and user ... (full steps: CIS section 2.2.25)

Como é corrigido

Método de correção: Orientação ou patch de infraestrutura

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

Propriedades

Sistemas operacionais: Qualquer
Tags: db2-zospermissions
Referência: CIS IBM Db2 13 for z/OS Benchmark v1.0.0 - 2.2.25 Ensure that access to SYSIBM.SYSSEQUENCES is restricted