User Data Record Layout and oSec Properties
VPM Enterprise encrypts the data you enter on the Users form before storing it in the Users table SDATAUsers. The encrypted user data is stored in the cData field of the Users table record. When a user logs into an application, the fields in the user’s encrypted record are decrypted and made available as properties of _SCREEN.oApp.oSec, the security object.
The following table shows the layout of the cData field in the User record. The table also provides the name of each User data field’s _SCREEN.oApp.oSec property.
Tip: “oSec” is the object reference of the Security object. When you refer to a User data field’s oSec property in your code, use the “_SCREEN.oApp.oSec.” prefix with the property name. For example, use _SCREEN.oApp.oSec.UserData_cUserID to refer to the current user’s ID.
|
Pos. |
Width |
Content Description |
oSec Property |
|
1 |
4 |
Check Sum |
|
|
5 |
20 |
User ID |
UserData_cUserID |
|
25 |
20 |
Password |
UserData_cPassword |
|
45 |
30 |
First Name |
UserData_cFirstName |
|
75 |
30 |
Middle Name |
UserData_cMiddleName |
|
105 |
30 |
Last Name |
UserData_cLastName |
|
135 |
20 |
User Number |
UserData_cUserNumber |
|
155 |
10 |
Password Date (mm/dd/yyyy) |
UserData_dPasswordDate |
|
165 |
3 |
Password Period Days (spaces or space-filled right-justified number) |
UserData_nPasswordPeriod |
|
168 |
1 |
Temporary Password Status (0 – No, 1 – Yes) |
|
|
169 |
1 |
Passwords Form Access Permission (0 – No, 1 – Yes) |
|
|
170 |
1 |
Picklist Add/Edit Permission (0 – No, 1 – Yes) |
UserData_lPicklistAddEditPermission |
|
171 |
1 |
Field Help Edit Permission (0 – No, 1 – Yes) |
UserData_lFieldHelpEditPermission |
|
172 |
1 |
Login Status (0 – No, 1 – Yes) |
|
|
173 |
1 |
Multiple Login Permission (0 – No, 1 – Yes) |
UserData_lMultipleLoginPermission |
|
174 |
3 |
Control Permission Group |
UserData_cControlPermissionGroup |
|
177 |
3 |
Field Permission Group |
UserData_cFieldPermissionGroup |
|
180 |
3 |
Menu Permission Group |
UserData_cMenuPermissionGroup |
|
183 |
1 |
Report Manager Type (1 – Edit & Run, 2 – Run Only) |
UserData_nReportManagerType |
|
184 |
1 |
Access Level (space, A-Z) |
UserData_cAccessLevel |
|
185 |
69 |
Filler |
UserData_cFiller |
|
255 |
1 |
Global Condition Add/Edit Permission (0 – No, 1 – Yes) |
UserData_lGlobalConditionsAddEditPermission |
User Security Mistakes and How to Recover