HomeMogDBMogDB StackUqbar
v2.0

Documentation:v2.0

Supported Versions:

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
roloid oid ID of a 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 a role
tempspace bigint Size of the temporary table storage space used by a role
passwordexpired smallint Whether a password is valid.
- 0: The password is valid.
- 1: The password is invalid.
Copyright © 2011-2024 www.enmotech.com All rights reserved.