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.