PG_SHADOW

PG_SHADOW displays the attributes of all roles marked with rolcanlogin in PG_AUTHID. Only users with the SYSADMIN permission can access this system view.

The information in this view is basically the same as that of the view in PG_USER. The difference is that passwords are sensitive and displayed as ******** in the latter.

**Table 1** PG_SHADOW columns
Name	Type	Reference	Description
usename	name	rolname in PG_AUTHID	Username.
usesysid	oid	oid in PG_AUTHID	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 a SYSADMIN. t (true): yes. f (false): no.
usecatupd	Boolean	-	Specifies whether the user can update a view. Even the SYSADMIN cannot update the view unless this column is t. 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	rolpassword in PG_AUTHID	Password ciphertext. If there is no password, the value is NULL.
valbegin	timestamp with time zone	-	Start time for account validity (NULL if start time is not specified).
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[]	setconfig in PG_DB_ROLE_SETTING	Default value of runtime configuration items.
tempspacelimit	text	-	Storage space of the temporary table, in KB.
spillspacelimit	text	-	Operator disk flushing space, in KB.
usemonitoradmin	Boolean	-	Specifies whether the user has the MONADMIN permission. t (true): yes. f (false): no.
useoperatoradmin	Boolean	-	Specifies whether the user has OPRADMIN permission. t (true): yes. f (false): no.
usepolicyadmin	Boolean	-	Specifies whether the user has the POLADMIN permission. t (true): yes. f (false): no.