PG_USER
PG_USER displays information about users who can access the database.
| Name | Type | Description |
|---|---|---|
| usename | name | User name |
| usesysid | oid | ID of this user |
| usecreatedb | Boolean | Whether the user has the permission to create databases |
| usesuper | Boolean | whether the user is the initial system administrator with the highest rights. |
| usecatupd | Boolean | whether the user can directly update system tables. Only the initial system administrator whose usesysid is 10 has this permission. It is not available for other users. |
| userepl | Boolean | Whether the user has the permission to duplicate data streams |
| passwd | text | Encrypted user password. The value is displayed as ********. |
| valbegin | timestamp with time zone | Account validity start time; null if no start time |
| valuntil | timestamp with time zone | Password expiry time; null if no expiration |
| respool | name | Resource pool where the user is in |
| parentid | oid | Parent user OID |
| spacelimit | text | The storage space of the permanent table. |
| tempspacelimit | text | The storage space of the temporary table. |
| spillspacelimit | text | The operator disk flushing space. |
| useconfig | text[] | Session defaults for run-time configuration variables |
| nodegroup | name | Name of the logical cluster associated with the user. If no logical cluster is associated, this column is left blank. |
Last Article: PG_TOTAL_USER_RESOURCE_INFO
Next Article: PG_USER_MAPPINGS
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.