XDBACF Database

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

The XDBACF database contains the following tables and columns:

• SYSXDB.SYSACFUSERS contains a list of all users, including the following information for each user:

  AuthID	AccessAuthority
  SecondaryID	RequirePassword
  Password	UserType
  DateOP (date of password)	Remarks
  TimeOP (time of password)

  Note:

  If you are a super user, do not edit or update a user's PASSWORD or TIMEOP in this table. Use the SQLWizard 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:

  Priority	MaxIdleTime
  MaxNumApiCalls	MaxFetches
  MaxTimeEngine	StartFreeTime
  MaxTimePerApi	EndFreeTime

• SYSXDB.SYSUSERPRIORITY contains information about priorities that have been assigned to users.

See the SQL Reference for the specific format of each of these tables.