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

userprflastactivetime

timestamp with time zone

Time the user's session was last checked

userprfpasswordrolloverexpire

timestamp with time zone

Time at which the period in which old and new passwords can be used ends