PG_AUTHID v18
The PG_AUTHID view provides information about database authorization identifiers (that is, roles). A role includes users and groups.
In addition to the information in the PostgreSQL pg_authid description, EDB Postgres Advanced Server provides the following information.
Additional columns in EDB Postgres Advanced Server
| 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 user login. If the value is NULL, the user hasn't logged in to the database. |
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.