If password authentication fails consecutively, the user is locked and cannot log in.

If you want to allow a locked user to log in again, unlock the user. The pgx_unlock_user function releases the lock. Operations can be performed by users with CREATEROLE privilege.

Refer to "B.3.2 User Management Functions" for functions.

[Example]

SELECT pgx_unlock_user('user1');

To release a lock when a database administrator is locked, users other than the locked user with CREATEROLE privilege can do so. If the user does not exist, Fujitsu Enterprise Postgres must be started in single-user mode and the lock released.

When a password life time is over, the password expires and cannot be used to connect to and operate on the database until the password is changed.

The password can be changed by the expired user itself, or by a user who has the CREATEROLE privilege and who is an administrator of that user (who has ADMIN privilege for that user).