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:
- 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:
- 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.
