PG_USER_STATUS
PG_USER_STATUS records the states of users that access to the database. It is accessible only to users with system administrator rights.
Column |
Type |
Description |
---|---|---|
roloid |
OID |
ID of the role |
failcount |
Integer |
Specifies the number of failed attempts. |
locktime |
Timestamp with time zone |
Time at which the role is locked |
rolstatus |
Smallint |
Role state
|
permspace |
Bigint |
Size of the permanent table storage space used by a role in the current instance. |
tempspace |
Bigint |
Size of the temporary table storage space used by a role in the current instance. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.