User Groups

User groups define groups of users and/or wildcard patterns that match usernames:

CREATE TABLE usergrp (
    id INTEGER PRIMARY,
    name TEXT UNIQUE,
    description TEXT,
    disabled INTEGER CHECK(disabled BETWEEN 0 AND 1), -- 0=enabled, 1=disabled
    type CHAR(1) CHECK (type IN ('I','E')), -- I=internal, E=external
    extinfo TEXT -- external lookup info
);
CREATE TABLE userlist (
    id INTEGER REFERENCES usergrp(id),
    user TEXT, -- "glob" wildcard
PRIMARY KEY(id,user)
);

Each user group has multiple user list entries that specify names, wildcards, or both, that match both submit and run user names when matched by the role.

A diagram demonstrating that each User Group has multiple User List entries.