The USERSECURITY table stores information that has been entered on the General and Security tabs of a user profile. This table contains information for a user's access level, whether a user can create new teams, add or remove team members, Administrative roles assigned to user, and other details associated with security and general functions of Infor CRM.
| Field | Datatype (Length) | Allow Nulls | Indexes | Values | Relationship | Related Table and Field |
|---|---|---|---|---|---|---|
|
USERID (PK) (FK) |
STANDARDID(12) |
NOT NULL |
USERSECURITY_USERID_PK (CA) |
|
(One) to (Many) |
|
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (One) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (One) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (One) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
(One) to (Many) |
||||||
|
USERCODE |
varchar(30) |
NULLS |
USERSECURITY_USERCODE (IE) |
|
|
|
|
TYPE |
BOOLEAN(1) |
NULLS |
USERSECURITY_TYPE (IE) |
User Types: |
|
|
|
ACCESSLEVEL |
varchar(20) |
NULLS |
|
|
|
|
|
CLIENTLOGPTR |
STANDARDID(12) |
NULLS |
|
|
|
|
|
HOSTLOGPTR |
STANDARDID(12) |
NULLS |
|
|
|
|
|
LOGTHRESHOLD |
smallint(2) |
NULLS |
|
|
|
|
|
MANAGERID (FK) |
STANDARDID(12) |
NULLS |
|
|
(Many) to (One) |
USERSECURITY.USERID |
|
DEFAULTSECCODEID (FK) |
STANDARDID(12) |
NOT NULL |
USERSECURITY_DEFAULTSECCODEID (IE) |
|
(Many) to (One)* limited to 1:1 by application |
|
|
(One) to (One) |
||||||
|
ADDMEMBERS |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
DELMEMBERS |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
CREATETEAMS |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
ISMANAGER |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
FUNCTIONS |
varchar(255) |
NULLS |
|
|
|
|
|
ENABLED |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
PRIVATEACCOUNTID(FK) |
STANDARDID(12) |
NULLS |
|
|
(Many) to (One) |
USERSECURITY.USERID |
|
PRIMARYSITE (FK) |
STANDARDID(12) |
NULLS |
USERSECURITY_PRIMARYSITE (IE) |
|
(Many) to (One) |
|
|
LASTRNFILE |
int(4) |
NULLS |
|
|
|
|
|
LASTSENDDATE |
datetime(8) |
NULLS |
|
|
|
|
|
SECURITY |
DATABLOB |
NULLS |
|
|
|
|
|
USERPW |
varchar(128) |
NULLS |
|
|
|
|
|
SUPPORTUSER |
BOOLEAN(1) |
NULLS |
|
|
|
|
|
ADMINROLE |
STANDARDID(12) |
NULLS |
|
|
|
|
|
USERTEMPLATE |
varchar(30) |
NULLS |
|
|
|
|
|
ISWEBADMIN |
char(1) |
NULLS |
|
|
|
|
|
CUSTOMERSERVICEUSER |
char(1) |
NULLS |
|
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
(Many) to (One) |
|
|
PWCHANGEDATE |
datetime(8) |
NULLS |
|
|
|
|
|
LOGINATTEMPTS |
smallint |
NULLS |
|
|
|
|
|
FAILEDATTEMPTDATE |
datetime(8) |
NULLS |
|
|
|
|
| PASSWORDRESETTOKEN | varchar(32) | NULLS | ||||
| TOKENEXPIRATION | datetime(8) | NULLS |