USERSECFUNCTIONS Table

Added in Version 6.2

The USERSECFUNCTIONS table defines Secured Functions to which a user does not have access.

  • If an index entry appears in multiple table columns, then it is a composite index. A composite index requires multiple columns in order to create a unique index.

  • While this table does not have a field defined as a primary key, the USERID field should be unique and considered a primary key.

Legend
 

Field Datatype (Length) Allow Nulls Indexes Relationship Related Table and Field

USERID (FK)

char(12)

NOT NULL

USERSECFUNCTIONS_COMPOSITE (IE)

(Many) to (One)

USERSECURITY.USERID

FUNCTIONNAME

varchar(128)

NULLS

USERSECFUNCTIONS_COMPOSITE (IE)

 

 

MODIFYDATE

datetime(8)

NULLS

 

 

 

MODIFYUSER (FK)

char(12)

NULLS

 

(Many) to (One)

USERINFO.USERID

CREATEDATE

datetime(8)

NULLS

 

 

 

CREATEUSER (FK)

char(12)

NULLS

 

(Many) to (One)

USERINFO.USERID