Password profiles system catalogs v18
The password_profile extension creates the system catalogs that stores profile information.
pg_catalog.pg_profile
The pg_catalog.pg_profile system catalog stores information about the profiles and the password management rules added to that profile.
| Column | Description |
|---|---|
oid | The unique number to identify a profile.oid is assigned to a profile by a sequence. |
prfname | Name of the profile. |
prffailedloginattempts | Number of failed login attempts allowed by the profile. |
prfpasswordlocktime | Locking duration in seconds after a role is locked. |
prfpasswordlifetime | Validity of current role password in seconds. |
prfpasswordgracetime | Duration in seconds after password expiration during which the role can still log in and change the password. |
prfpasswordverifyfuncdb | The database OID in which the password verify function is created. |
prfpasswordverifyfunc | The password verify function name created by a user to impose password rules. |
pg_catalog.pg_auth_profile
| Column | Description |
|---|---|
roleid | The unique number to identify a role. |
profileid | The object identifier for the role's profile. |
roleaccountstatus | Account status of the role. |
rolefailedlogins | Number of login failures of the role. |
rolelockdate | The timestamp when the role was last locked. |
rolepasswordsetat | The timestamp when the role's password was last set or modified. |
rolepasswordexpire | The timestamp when the role's password expires. |
pg_catalog.pg_profile_info
The pg_catalog.pg_profile_info system catalog view stores information about the profiles and the corresponding parameter values.
| Column | Description |
|---|---|
profile_name | Name of the profile. |
failed_login_attempts | Number of failed login attempts allowed by the profile. |
password_lock_time | Locking duration in days after a role is locked. |
password_life_time | Validity of current role password in days. |
password_grace_time | Duration in days after password expiration during which the role can still log in and change the password. |
password_verify_function | The password verify function name created by a user, in <database name>.<schema name>.<function name> format, to impose password rules. |
pg_catalog.pg_role_profile_info
The pg_catalog.pg_role_profile_info system catalog view stores information about the roles and their associated profiles.
| Column | Description |
|---|---|
role_name | Name of the role. |
profile_name | Name of the profile associated with the role. |
role_status | Status of the role. |
role_lock_date | The timestamp when the role was last locked. |
role_expiry_date | The timestamp when the role's password expires. |