Abstract

A system is disclosed in which every principal of a mixed workforce — human, AI agent or service — can hold an organizational role only through a role record whose completeness the database enforces rather than reports. The role record binds three mandatory legs: an organizational position from a position catalog; a list of access-control role identifiers with at least one element, every element of a null-free list having to resolve to the access-role catalog; and at least one duty, recorded in a separate duty table as a system or standing duty the principal owns as accountable party or operates. Legs a declarative constraint can express are enforced when the row is written; the catalog check and the duty leg are enforced by a deferred per-row check at transaction commit, so a record and its duties can be written in any order within one transaction and a record found incomplete is refused with its transaction. A second deferred check on the duty table refuses, at commit, the deletion or reassignment of a principal's last duty while that principal still holds a role record, and stands down when the principal is removed, holding the duty leg from both sides of the one-to-many relation for transactions whose commit-time checks do not interleave. A validity flag defaults to false and is assigned only by a before-write routine, so a row inserted with that routine suppressed, not supplying the flag, stays false; a pure dry-run validator reports every missing leg.

Creative Commons License

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.

Share

COinS