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.
|
