PG_ROLES v18
The PG_ROLES view provides information about the database roles. It provides information specific to EDB Postgres Advanced Server in addition to the information provided in PostgreSQL pg_roles view.
| Name | Type | Description |
|---|---|---|
| rolredwoodprivs | Integer | Specified whether the role has redwood specific privileges |
| rolprofile | Oid | Object identifier for the role's profile |
| rolaccountstatus | Smallint | Account status of the role |
| rolfailedlogins | Integer | Number of failed login attempts. This parameter is internally updated when login is denied due to authentication failure. If this count exceeds the limit specified in its profile, the role is locked. On successful login, this counter is reset to 0. Explicit use of the ACCOUNT clause to ALTER ROLE can also reset this counter to 0. |
| rolpasswordsetat | Timestamp with time zone | Specifies the password set time, it is null if password is not set |
| rollockdate | Timestamp with time zone | The time when the account was last locked; null if the account was never locked before |
| rolpasswordexpire | Timestamp with time zone | The time after which a password change is forced at the next login |
| rollastlogin | Timestamp with time zone | Specifies the time of the last role login. |
Viewing privileges
There are functions designed to check redwood specific privileges for a role. They are useful for verifying permissions within SQL commands or for troubleshooting access issues. For more information see, functions to view redwood specific privileges.
- On this page
- Viewing privileges