PostgreSQL
TMA-POSTGRES-6.6
Ensure 'User' Runtime Parameters are Configured
RendahLevel 1Tinjauan manualpostgres
Deskripsi
These PostgreSQL runtime parameters are managed at the user account (ROLE) level.
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.
Run SELECT name, setting FROM pg_settings WHERE context = 'user' ORDER BY 1; and inspect role and database overrides (SELECT * FROM pg_db_role_setting; \drds). Any value that differs from your approved baseline is a fail.
Cara perbaikan
Metode perbaikan: Panduan atau patch infrastruktur
Reset unauthorized overrides with ALTER ROLE <role> [IN DATABASE <db>] RESET <parameter>; or ALTER DATABASE <db> RESET <parameter>; and correct the configuration files.
Properti
- Sistem operasi
- Apa saja
- Tag
- postgresdatabaseconfigurationmanual
- Referensi
- CIS PostgreSQL 18 Benchmark v1.0.0 - 6.6 Ensure 'User' Runtime Parameters are Configured