USERPWDHST

This table stores the previously used passwords of a registered user when the password policy of the user does not allow the reuse the previous two passwords or more. Each row of the table represents a password that has previously been used by the user. When a user changes their password, the change password process checks that the new password does not match any values for that user.

Column Descriptions:

NameTypeDescription
USERPWDHST_IDBIGINT NOT NULLA unique primary key for this table.
USERS_IDBIGINT NOT NULLID for the registered user. Foreign key to the USERREG table.
PREVLOGONPASSWORDBINARY NOT NULLThe encrypted user logon password that has been previously used.
SALTVARCHAR (254)The value that is appended to the password before hashing.
PASSWORDCREATIONTIMESTAMP NOT NULLThe time that the password was created.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>USERPWDHST_IDPrimary Key
I0001105USERS_ID+PASSWORDCREATIONUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3476USERS_IDUSERREGUSERS_IDCascade