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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035034980 | PLCYPASSWD_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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 |