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 | 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 |