The UAC adheres to and makes use of the HSE Default Configuration System. As such, you can find all relevant configuration files in the configured Unit subfolder of the config folder:

  /UAC_Config/Unit_SomeUnitId/

The UAC Manager requires a UAC Manager.ini configuration file. In this file, the db key defines which section in DB_CONNECTOR.ini (see below) to use:

  [global]
  ; The descriptor is used for the VI's Front Panel Window titlebar 
  ; and for the entries in the UI Manager's Run-Time Menu.
  descriptor = "User Access Control"
  
  ; Section to use in DB_CONNECTOR.ini
  db="UAC-DB-SQLite"

The DB_CONNECTOR will use the configuration data from the section defined via the db key in DB_CONNECTOR.ini for the database connection it provides to the UAC:

  [UAC-DB-SQLite]
  db-interface="DB-SQLite"
  filepath="[[HSE-UNIT-DIR]]\UAC-Database\UAC.db"
  timeout= 500

Refer to HSE Core: DB for more information.

DROP TABLE IF EXISTS acl;
CREATE TABLE acl(
  acl_id INTEGER PRIMARY KEY AUTOINCREMENT, 
  accessor_type NOT NULL, 
  accessor_id NOT NULL,
  element NOT NULL, 
  level NOT NULL,
  UNIQUE (accessor_type, accessor_id, element));

DROP TABLE IF EXISTS groups;
CREATE TABLE groups(
  group_id INTEGER PRIMARY KEY AUTOINCREMENT,
  name NOT NULL UNIQUE);

DROP TABLE IF EXISTS useringroups;
CREATE TABLE useringroups(
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  group_id NOT NULL,
  user_id NOT NULL
);

DROP TABLE IF EXISTS users;
CREATE TABLE users(
  user_id INTEGER PRIMARY KEY AUTOINCREMENT,
  first_name NOT NULL, 
  last_name NOT NULL, 
  username NOT NULL UNIQUE, 
  password NOT NULL, 
  meta_data 
);