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.