PLCYPASSWD

This table stores password policies.

Column Descriptions:

Name	Type	Description
PLCYPASSWD_ID	BIGINT NOT NULL	ID for the Password Policy table.
MINPASSWDLENGTH	INTEGER DEFAULT 8	The minimum password length.
MINALPHABETIC	INTEGER DEFAULT 1	The minimum number of alphabetic characters that should be in a password.
MINNUMERIC	INTEGER DEFAULT 1	The minimum number of numeric characters that should be in a password.
MAXINSTANCES	INTEGER DEFAULT 3	The maximum number of times a character can occur in a password.
MAXCONSECUTIVETYPE	INTEGER DEFAULT 4	The maximum number of consecutive character type allowed in a password.
MAXLIFETIME	INTEGER DEFAULT 90	The maximum number of days for which a password is valid, from the last time it is updated.
MATCHUSERID	INTEGER 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.
REUSEPASSWORD	INTEGER DEFAULT 0	Specifies 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.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PLCYPASSWD_ID	Primary Key

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_600	PLCYPASSWD_ID	PLCYACCT	PLCYPASSWD_ID	Cascade
F_604	PLCYPASSWD_ID	PLCYPWDDSC	PLCYPASSWD_ID	Cascade

Related reference
Authentication data model