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

 

More:

User Security Mistakes and How to Recover