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 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 tables. 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 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 end time is not specified).
respool	name	Resource pool where the user is in.
parent	oid	Parent user OID.
spacelimit	text	Storage space of the permanent table, in KB.
useconfig	text[]	Default value of runtime configuration items.
tempspacelimit	text	Storage space of the temporary table, in KB.
spillspacelimit	text	Operator disk spill space, in KB.
nodegroup	name	Name of the logical database associated with the user. If the user does not manage the logical database, this column is left blank.
usemonitoradmin	boolean	Specifies whether the user is a monitor administrator. 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.