XDBACF Database

The system location for each XDB Server contains a database called XDBACF (XDB Access Control Facility). This database contains information you enter for each user and group via the Admin menu commands. Information in the XDBACF database applies to all users and all locations on the server.

The XDBACF database contains the following tables and columns. For the specific format of each of these tables, see the topic List Of System Tables.

SYSXDB.SYSACFUSERS Contains a list of all users, including the following information for each user:
  • AuthID
  • SecondaryID
  • Password
  • DateOP (date of password)
  • TimeOP (time of password)
  • AccessAuthority
  • RequirePassword
  • UserType
  • Remarks
Note:

If you are a super user, do not edit or update a user's PASSWORD or TIMEOP information in this table. Use the Admin menu commands instead.

SYSXDB.SYSACFGROUPS Contains a list of all GroupIDs that have been defined. Columns in this table are:
  • GroupAuthID
  • Remarks
SYSXDB.SYSACFMEMBERS Contains a list of AuthIDs and the GroupIDs that each is authorized to use. Each user (Primary AuthID) can have several entries, one entry for each GroupID that the person is authorized to use. Columns in this table are:
  • UserAuthID
  • GroupAuthID
SYSXDB.SYSGOVERNOR Contains information on the type of activities that can be performed by certain users during certain periods. Columns in this table are:
  • EndFreeTime
  • MaxFetches
  • MaxIdleTime
  • MaxNumApiCalls
  • MaxTimeEngine
  • MaxTimePerApi
  • Priority
  • StartFreeTime
SYSXDB.SYSUSERPRIORITY Contains information about priorities that have been assigned to users.