PG_USER v18
The PG_USER view provides information about the database users. It provides information specific to EDB Postgres Advanced Server in addition to the information provided in the PostgreSQL pg_user view.
| Name | Type | Description |
|---|---|---|
| useredwoodprivs | Integer | Specified whether the role has redwood specific privileges |
| usepasswdsetat | Timestamp with time zone | Specifies the password set time, it is null if password is not set |
| useaccountstatus | Smallint | Account status of the user |
| uselockdate | Timestamp with time zone | The time when the account was last locked; null if the account was never locked before |
| usepasswordexpire | Timestamp with time zone | The time after which a password change is forced at the next login |
| uselastlogin | Timestamp with time zone | Specifies the time of the last user login. |
Viewing privileges
There are functions designed to check redwood specific privileges for a user. 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