Use the user_profile extension to enforce password policies and protect accounts in WarehousePG (WHPG). Group roles under a profile to set password complexity, expiration, and reuse rules, lock accounts after repeated failed logins, and give users a grace period to renew an expired password. A database superuser creates and manages the profiles, and WarehousePG applies the rules to the roles associated with each profile. Failed-login locking and password expiration apply only to password logins, as described in Limitations.
To get started with user_profile, see:
Release notes
Release notes for the user_profile extension for WarehousePG.
Installing and upgrading
Install, load, register, and upgrade the user_profile extension for WarehousePG.
Using
Create, alter, and assign profiles, and lock and unlock roles, to manage password policies and account security in WarehousePG.