user_profile

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.


Could this page be better? Report a problem or suggest an addition!