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 |
parent |
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. |
Example
Query the current database user list.
1 2 3 4 5 6 7 8 |
SELECT usename FROM pg_user; usename ----------- dbadmin u1 u2 u3 (4 rows) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot