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:

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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType