userprfroleid

oid

pg_authid.oid

User's identifier
(Primary key constraint)

userprfprfid

oid

pgx_profile.oid

Identifier of the profile assigned to the user

userprfaccountlock

smallint

User lock state
(NOT NULL constraint)
0: Not locked
1: Lock (Refer to PASSWORD_LOCK_TIME in profile for duration)
2: Lock (Unlimited)

userprfpasswordstatus

char

Password status
Updated if there are any changes at login
(NOT NULL constraint)
o: Current valid password
g: In grace period
e: Expired

userprflockdate

timestamp with time zone

Time the user was locked

userprfpasswordsetat

timestamp with time zone

Time you updated your current password

userprfpasswordexpire

timestamp with time zone

Password expiration time