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	ID of this user.
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. This permission 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 the start time is not specified).
valuntil	timestamp with time zone	End time for account validity (NULL if the 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.
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 monitor administrator. 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.