Secure the root User and Administrative Roles

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.

Run SHOW CLUSTER SETTING server.host_based_authentication.configuration; rules for root must use cert (cert-*) methods only and be limited to jump-host CIDRs, followed by host all root all reject. Run SHOW ROLES and SHOW GRANTS ON ROLE admin: membership of admin must be limited to approved administrators, and applications must not connect as root.

Como é corrigido

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

1. Enforce certificate-only authentication for root Update the HBA configuration to allow only certificate-based methods: SET CLUSTER SETTING server.host_based_authentication.configuration = ' TYPE DATABASE USER ADDRESS METHOD host all root <jumpbox-cidr> cert host all root all reject '; Replace <jumpbox-cidr> with your actual admin network. 2. Restrict root usage operationally - Replace script usage with least-privilege service accounts.