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 password is allowed to match the logon ID. Accepted values are:
  • (0) The password is not allowed to match the logon ID.
  • (1) The password is allowed to match the logon ID.
REUSEPASSWORDINTEGER DEFAULT 0Specifies whether the user's previous password(s) can be reused. Accepted values are:
  • 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.
  • (0) The last password cannot be reused.
  • (1) The last password can be reused.
OPTCOUNTERSMALLINTThe 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