PostgreSQL
TMA-POSTGRES-4.2
Ensure sudo is configured correctly
SedangLevel 1Tinjauan manualpostgres
Deskripsi
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.
Cara pemeriksaan
Metode audit: Tinjauan manual
Rekomendasi ini tidak dapat diperiksa secara otomatis. Pemindaian akan menampilkannya beserta petunjuk ini saat Anda memberikan opsi --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.
Cara perbaikan
Metode perbaikan: Panduan atau patch infrastruktur
Create a DBA group, add authorized users, and add '%dba ALL=(postgres) PASSWD: ALL' via visudo -f /etc/sudoers.d/postgres.
Properti
- Sistem operasi
- Apa saja
- Tag
- postgresdatabaseauthenticationsudomanual
- Referensi
- CIS PostgreSQL 18 Benchmark v1.0.0 - 4.2 Ensure sudo is configured correctly