Ensure sudo is configured correctly

中级别 1人工审核postgres

说明

It is common to have more than one authorized individual administering the PostgreSQL service at the Operating System level. It is also quite common to permit login privileges to individuals on a PostgreSQL host who otherwise are not authorized to access the server's data cluster and files.

检查方式

审计方法: 人工审核

此项建议无法自动检查。当您传入 --include-manual 时，扫描结果会列出该项并附带这些说明。

Check /etc/sudoers and /etc/sudoers.d: only an approved DBA group (e.g. %dba) may run commands as postgres. Test with an unauthorized user (sudo -iu postgres must be refused) and an authorized one.

修复方式

修复方法: 操作指南或基础设施补丁

Create a DBA group, add authorized users, and add '%dba ALL=(postgres) PASSWD: ALL' via visudo -f /etc/sudoers.d/postgres.

属性

操作系统: 任意
标签: postgresdatabaseauthenticationsudomanual
参考: CIS PostgreSQL 18 Benchmark v1.0.0 - 4.2 Ensure sudo is configured correctly