PLCYPASSWD

This table stores password policies.

Column Descriptions:

NameTypeDescription
PLCYPASSWD_IDBIGINT NOT NULLID for the Password Policy table.
MINPASSWDLENGTHINTEGER DEFAULT 8The minimum password length.
MINALPHABETICINTEGER DEFAULT 1The minimum number of alphabetic characters that should be in a password.
MINNUMERICINTEGER DEFAULT 1The minimum number of numeric characters that should be in a password.
MAXINSTANCESINTEGER DEFAULT 3The maximum number of times a character can occur in a password.
MAXCONSECUTIVETYPEINTEGER DEFAULT 4The maximum number of consecutive character type allowed in a password.
MAXLIFETIMEINTEGER DEFAULT 90The maximum number of days for which a password is valid, from the last time it is updated.
MATCHUSERIDINTEGER DEFAULT 0Specifies whether the user ID and password can match: (0) if user ID and password do not match. (1) if user ID and password can match.
REUSEPASSWORDINTEGER DEFAULT 0Specifies whether the user's previous password(s) can be reused. Valid values are: (0) last password cannot be reused. (1) last password can be reused. Negative numbers indicate that the last n passwords cannot be reused. For example, -4 means that the last 4 passwords cannot be reused. Note: -1 and 0 both mean that the last password cannot be reused.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PLCYPASSWD_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_600PLCYPASSWD_IDPLCYACCTPLCYPASSWD_IDCascade
F_604PLCYPASSWD_IDPLCYPWDDSCPLCYPASSWD_IDCascade