Skip to main content

ban-alter-database-options

problem​

ALTER DATABASE options and configuration changes can change connection behaviour, name resolution, or results for existing clients in the database. This rule is opt-in. It does not report database renames, owner changes, or tablespace changes.

ALTER DATABASE app SET search_path TO public;
ALTER DATABASE app WITH CONNECTION LIMIT 20;

solution​

Review clients before changing database settings. Enable this rule with --include ban-alter-database-options.