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