View sola.system.user_pword_expiry
Determines the number of days until the users password expires. Once the number of days reaches 0, users will not be able to log into SOLA unless they have the ManageSecurity role (i.e. role to change manage user accounts) or the NoPasswordExpiry role. To configure the number of days before a password expires, set the pword-expiry-days setting in system.setting table. If this setting is not in place, then a password expiry does not apply.

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
uname varchar 40  √  null
last_pword_change timestamp 29,6  √  null
pword_change_user varchar 50  √  null
no_pword_expiry bool 1  √  null
pword_expiry_days int4 10  √  null

Analyzed at Tue May 31 09:59 NZST 2016