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.