Ensure 'User' Runtime Parameters are Configured

Kako se proverava

Metod provere: Ručni pregled

Ova preporuka se ne može proveriti automatski. Skeniranje je navodi sa ovim uputstvima kada prosledite --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.

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

Reset unauthorized overrides with ALTER ROLE <role> [IN DATABASE <db>] RESET <parameter>; or ALTER DATABASE <db> RESET <parameter>; and correct the configuration files.