KNTA_PASSWORD_CHANGES

This table stores list of old passwords previously used by all users. This table is used when password reuse is restricted by PPM Center Administrator.

Note: For records to be inserted into this table the PASSWORD_REUSE_RESTRICTION_DAYS server.conf parameter should be set to a value of more than 0.

Any rows that are beyond the reuse restriction time will be purged.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_USERS	USER_ID	USER_ID

Column Descriptions

Column Name	Null?	Data Type	Description
PASSWORD_CHANGE_ID	NOT NULL	NUMBER	System-generated identifier
CREATION_DATE	NOT NULL	DATE	Date record was created
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
USER_ID	NOT NULL	NUMBER	User who own the old password
PASSWORD_CHANGE_DATE	NOT NULL	DATE	Date password become obsolete
PASSWORD	NULLABLE	VARCHAR2(200)	Old password

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_PASSWORD_CHANGES_N1	NONUNIQUE	1	USER_ID
KNTA_PASSWORD_CHANGES_U1	UNIQUE	1	PASSWORD_CHANGE_ID

Sequences

Sequence Name	Sequence Type
KNTA_PASSWORD_CHANGES_S	PASSWORD_CHANGE_ID