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.
|