This table stores user authentication information.
Column Description(s):
Column Name | Column Type | Description |
USERS_ID |
BIGINT NOT NULL |
ID for the user member. Foreign key to the USERS table. |
STATUS |
INTEGER |
Allows the user to have the logon ID disabled without removing the user from the system. Valid values are as follows:
|
PLCYACCT_ID |
INTEGER |
The account policy for this user, foreign key to the PLCYACCT table. |
LOGONID |
VARCHAR(254) NOT NULL |
The user logon ID. |
LOGONPASSWORD |
BINARY |
The encrypted user logon password. Compare with the SHLPSWD column of the SHOPPER table provided with previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
PASSWORDEXPIRED |
INTEGER |
Specifies whether or not the user password has expired. Valid values are 0 (not expired) or 1 (expired). |
CHALLENGEQUESTION |
VARCHAR(254) |
Challenge question for confirmation of the user identity. Compare with the SCHAQUE column of the SHOPPER table provided with previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
CHALLENGEANSWER |
VARCHAR(254) |
Answer to challenge question. Compare with the SHCHAANS column of the SHOPPER table provided with previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
TIMEOUT |
BIGINT NOT NULL DEFAULT -1 |
Time for which the user cannot log in after failed attempts to log in. |
PASSWORDRETRIES |
INTEGER DEFAULT 0 |
The number of times consecutively the password is entered incorrectly. |
SALT |
VARCHAR(254) |
The value that is prepended to the password before hashing. |
PASSWORDCREATION |
TIMESTAMP |
The last time the password for the user was created or updated. |
PASSWORDINVALID |
TIMESTAMP |
Timestamp of the last failed attempt to log in. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000260 |
LOGONID |
Unique Index |
SQL050212031325160 |
USERS_ID |
Primary Key |
I0000330 |
PLCYACCT_ID |
Non-Unique Index |
I716117 |
LOGONID+USERS_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_894 |
PLCYACCT_ID |
PLCYACCT |
PLCYACCT_ID |
Cascade |
F_895 |
USERS_ID |
USERS |
USERS_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.