GS_SHADOW
GS_SHADOW displays the attributes of all roles marked with rolcanlogin in PG_AUTHID. Only the system administrator can access this system view.
The information in this view is basically the same as that of the view in GS_USER. The difference is that passwords are sensitive and displayed as ******** in the latter.
Name |
Type |
Reference |
Description |
---|---|---|---|
usename |
name |
rolname in PG_AUTHID |
Username. |
usesysid |
oid |
oid in PG_AUTHID |
User ID. |
usecreatedb |
Boolean |
- |
Specifies whether a user has the permissions to create databases.
|
usesuper |
Boolean |
- |
Specifies whether the user is a system administrator.
|
usecatupd |
Boolean |
- |
Specifies whether the user can update a view. Even the system administrator cannot update the view unless this column is t.
|
userepl |
Boolean |
- |
Specifies whether the user has the permissions to duplicate data streams.
|
passwd |
text |
rolpassword in PG_AUTHID |
Password ciphertext. If there is no password, the value is NULL. |
valbegin |
timestamp with time zone |
- |
Account validity start time. If this column is not set, the value is NULL. |
valuntil |
timestamp with time zone |
- |
Account validity end time. If this column is not set, the value is NULL. |
respool |
name |
- |
Resource pool where the user is in. |
parent |
oid |
- |
Parent user OID. |
spacelimit |
text |
- |
Storage space of the permanent table, in KB. |
useconfig |
text[] |
setconfig in PG_DB_ROLE_SETTING |
Default value of runtime configuration items. |
tempspacelimit |
text |
- |
Storage space of the temporary table, in KB. |
spillspacelimit |
text |
- |
Operator disk flushing space, in KB. |
usemonitoradmin |
Boolean |
- |
Specifies whether the user is a monitor administrator.
|
useoperatoradmin |
Boolean |
- |
Specifies whether the user is an O&M administrator.
|
usepolicyadmin |
Boolean |
- |
Specifies whether the user is a security policy administrator.
|
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