User Table

The User Table (User_tb) contains a record for every user in the Sterling Gentran:Server® system.

The translator creates a record when you create a user. The translator updates a record when you change user information. The translator deletes a record when you delete a user from the system.

Table 1. User Table field information
Field Name Type Size Use
UserIDKEY string 20 System-generated unique key that identifies the user.
UserName string 42 Name of the user.
Password string 126 User password.
AccessCtlMatrix number (long) 4 Type of access the user has to the Sterling Gentran:Server system. The system "logically ors" these values when you select more than one:
  • 1 = System administration
  • 2 = Partner administration
  • 4 = Send/receive
  • 8 = Import
  • 16 = Export
  • 32 = Screen entry
  • 64 = Unattended