Database Table: PLCYPASSWD

This table stores password policies.

Column Name Column Type Column Description
MATCHUSERID INTEGER
NULL, DEFAULT 0
Specifies 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.
MAXCONSECUTIVETYPE INTEGER
NULL, DEFAULT 4
The maximum number of consecutive character type allowed in a password.
MAXINSTANCES INTEGER
NULL, DEFAULT 3
The maximum number of times a character can occur in a password.
MAXLIFETIME INTEGER
NULL, DEFAULT 90
The maximum number of days a password is valid for, from the last update.
MINALPHABETIC INTEGER
NULL, DEFAULT 1
The minimum password alphabetic characters that should be in a password.
MINNUMERIC INTEGER
NULL, DEFAULT 1
The minimum password numeric characters that should be in a password.
MINPASSWDLENGTH INTEGER
NULL, DEFAULT 8
The minimum password length.
PLCYPASSWD_ID BIGINT
NOT NULL
ID for the Password Policy table.
REUSEPASSWORD INTEGER
NULL, DEFAULT 0
Specifies whether the users previous password can be reused. (0) last password cannot be reused. (1) last password can be reused.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035034980 PLCYPASSWD_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_600 PLCYPASSWD_ID PLCYACCT PLCYPASSWD_ID Cascade
F_604 PLCYPASSWD_ID PLCYPWDDSC PLCYPASSWD_ID Cascade