MTD_USER
MTD_USER displays information about all current users. It is used only for table association in internal views and is not recommended for external use.
Name |
Type |
Description |
---|---|---|
dbid |
oid |
Database ID. |
usename |
name |
Username. |
usesysid |
oid |
User ID. |
usecreatedb |
boolean |
Specifies whether a user has the permissions to create databases.
|
usesuper |
boolean |
Specifies whether the user is the initial system administrator with the highest permissions.
|
usecatupd |
boolean |
Specifies whether the user can directly update system catalogs. Only the initial system administrator whose usesysid is 10 has this permission. This permission is unavailable for other users.
|
userepl |
boolean |
Specifies whether the user has the permissions to duplicate data streams.
|
passwd |
text |
Encrypted user password. The value is displayed as ********. |
valbegin |
timestamp with time zone |
Start time for account validity (NULL if no start time). |
valuntil |
timestamp with time zone |
End time for account validity (NULL if no end time). |
respool |
name |
Resource pool where the user is in. |
parent |
oid |
Parent user OID. |
spacelimit |
text |
Storage space of a permanent table, in KB. |
useconfig |
text |
Default value of GUC items. For details, see section "PG_DB_ROLE_SETTING.setconfig." |
nodegroup |
name |
Name of a logical database associated with a user. If the user does not manage the logical database, this column is left blank. |
tempspacelimit |
text |
Storage space of a temporary table, in KB. |
spillspacelimit |
text |
Operator disk spill space, in KB. |
usemonitoradmin |
boolean |
Specifies whether this user is a MONADMIN.
|
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