Updated on 2025-05-29 GMT+08:00

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.

Table 1 MTD_USER columns

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.

  • t (true): yes.
  • f (false): no.

usesuper

boolean

Specifies whether the user is the initial system administrator with the highest permissions.

  • t (true): yes.
  • f (false): no.

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.

  • t (true): yes.
  • f (false): no.

userepl

boolean

Specifies whether the user has the permissions to duplicate data streams.

  • t (true): yes.
  • f (false): no.

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.

  • t (true): yes.
  • f (false): no.

useoperatoradmin

boolean

Specifies whether the user is an O&M administrator.

  • t (true): yes.
  • f (false): no.

usepolicyadmin

boolean

Specifies whether the user is a security policy administrator.

  • t (true): yes.
  • f (false): no.