When you create a database user with CREATE ROLE, the database user is assigned the default profile. When you create the default profile, all password configuration and authentication restrictions and the gradual password rollover feature are disabled, so change the parameter values to suit your policy. Change the value with the pgx_alter_profile function.

Users with CREATEROLE privilege can modify the contents of a profile.

Refer to "B.3.1 Profile Management Functions" for functions.

Refer to "7.7 Profile parameters" for more information on parameters.

[Example]

SELECT pgx_alter_profile('default',
‘{
    "INACTIVE_USER_TIME": 30,
    "PASSWORD_LIFE_TIME": 50,
    "PASSWORD_GRACE_TIME": 10,
    "PASSWORD_REUSE_MAX": 5,
    "PASSWORD_LOCK_TIME": 0.5,
    "PASSWORD_ALLOW_HASHED": true,
    "PASSWORD_ROLLOVER_TIME": 0.125
}’);