PG_USER

PG_USER displays information about database users. By default, only the initial user and users with the SYSADMIN attribute can view the information. Other users can view the information only after being granted with permissions.

**Table 1** PG_USER columns
Name	Type	Description
usename	name	Username.
usesysid	oid	User ID.
usecreatedb	Boolean	Specifies whether this user has the permissions to create databases. t (true): yes. f (false): no.
usesuper	Boolean	Specifies whether this 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. It is unavailable for other users. t (true): yes. f (false): no.
userepl	Boolean	Specifies whether this 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 end time is not specified).
respool	name	Resource pool where this user is in.
parent	oid	Parent user OID.
spacelimit	text	Storage space of the permanent table, in KB.
useconfig	text[]	Default value of GUC items. For details, see setconfig in PG_DB_ROLE_SETTING.
nodegroup	name	Name of the node group associated with a user. If the user does not manage node groups, leave it blank.
tempspacelimit	text	Storage space of the temporary table, in KB.
spillspacelimit	text	Operator disk flushing space, in KB.
usemonitoradmin	Boolean	Specifies whether this user is a MONADMIN. t (true): yes. f (false): no.
useoperatoradmin	Boolean	Specifies whether this user is an O&M administrator. t (true): yes. f (false): no.
usepolicyadmin	Boolean	Specifies whether this user is a security policy administrator. t (true): yes. f (false): no.