HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

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
oid oid Row identifier (hidden attribute, which must be specified)
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.