Data Access Rights Table

STEPforward controls access to data on the data field and user level. That is, every data field maintains an access mask for every user registered with STEPforward. The access masks are stored in SF_SYSDataAccess table that has the following structure:

Column Generalized data type Use
TemplateName VARCHAR(8) Name of Global, Subledger or Transaction Template
CloneName VARCHAR(8) Name of Template clone
Type CHAR(1) Template type (base or clone)
Domain CHAR(1) Domain of the Template (M or T)
FieldName VARCHAR(31) System name of data field
UserId VARCHAR(255) User Id of the registered user
AccessCode TINYINT Access code
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

Notes:

CloneName is set to an empty string for base Templates.

Type is a one-character code that marks the Template as being of the base (B) or clone (C) type.

Domain is a one-character code that identifies the Template as belonging to the category of the accounting transaction data (T) or general data (M) which includes both Global and Subledger categories.

FieldName is the system name of the data field.

UserId is the login account of the registered user. Empty string in this field means "Other" account; those users whose login accounts are not recorded in SF_SYSDataAccess table are treated as "Other" users, and receive the access mask set for this user id (the default access mask).

AccessCode sets specific type of access permitted to the user "UserId" on the filed "FieldName". The following access codes are valid:

0 No access (the field is blanked out)
1 Read only (no updates)
2 Read and write (full access)

The following is a partial sample of contents of SF_SYSDataAccess table:

TemplateName CloneName Type Domain FieldName                       UserId     AccessCode
------------ --------- ---- ------ ------------------------------- ---------- ----------
Name                   B    M      Date_Time_Button                alex       1
Name                   B    M      Date_Time_Button                alexnet    1
Name                   B    M      Date_Time_Button                heidi      1
Name                   B    M      Date_Time_Button                helga      1
Name                   B    M      Date_Time_Button                hold       1
Name                   B    M      Date_Time_Button                wolf       1
Name                   B    M      Date_Time_Button                wr         1
Name                   B    M      Date_Time_Button                           1
Name                   B    M      History                         alex       2
Name                   B    M      History                         alexnet    2
Name                   B    M      History                         heidi      2
Name                   B    M      History                         helga      2
Name                   B    M      History                         hold       2
Name                   B    M      History                         wolf       2
Name                   B    M      History                         wr         2
Name                   B    M      History                                    2