PG_SHADOW
PG_SHADOW displays properties of all roles that are marked as rolcanlogin in PG_AUTHID.
This view is not readable to all users because it contains passwords. PG_USER is a publicly readable view on PG_SHADOW that blanks out the password column.
Name |
Type |
Reference |
Description |
---|---|---|---|
usename |
name |
PG_AUTHID.rolname |
User name |
usesysid |
oid |
PG_AUTHID.oid |
ID of a user |
usecreatedb |
boolean |
- |
Indicates that the user can create databases. |
usesuper |
boolean |
- |
Indicates that the user is an administrator. |
usecatupd |
boolean |
- |
Indicates that the user can update system catalogs. Even the system administrator cannot do this unless this column is true. |
userepl |
boolean |
- |
User can initiate streaming replication and put the system in and out of backup mode. |
passwd |
text |
- |
Password (possibly encrypted); null if none. See PG_AUTHID for details about how encrypted passwords are stored. |
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 used by the user |
parent |
oid |
- |
Parent resource pool |
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 runtime configuration variables |
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