PG_USER_STATUS

PG_USER_STATUS provides the states of users who access the database. This system catalog is accessible only to system administrators.

Table 1 PG_USER_STATUS columns

Name	Type	Description
oid	oid	Row identifier (hidden attribute, which must be specified)
roloid	oid	ID of the role
failcount	integer	Number of failed attempts
locktime	timestamp with time zone	Time at which the role is locked
rolstatus	smallint	Role state 0: normal 1: The role is locked for a specific period of time because the failed login attempts exceed the threshold. 2: The role is locked by the administrator.
permspace	bigint	Size of the permanent table storage space used by the role
tempspace	bigint	Size of the temporary table storage space used by the role
passwordexpired	smallint	Whether a password is valid. 0: The password is valid. 1: The password is invalid.