We want to be able to craft policies by an expression instead of creating loaders or tons of reference groups based on cartesian products of basis/ref groups.
Individual groups can be configured to automatically have their membership managed with individual subject or other basis groups.
Tables
Two Grouper tables will be constructed
| Table name | Description |
|---|---|
| grouper_abac_group_attributes | Rows for groups and attribute names and values |
| grouper_abac_subject_attributes | Row for subjects and attribute names and values |
These tables are managed by grouper based on configuration.
Group attribute table
The group attribute values come from the attribute framework which could be automatically fed from external systems of record. For now, an OtherJob could do this on a schedule.
| grouper_abac_group_attributes | |||||
| Group name | Attribute name | Attribute value | Active | Next start time | Last end time |
|---|---|---|---|---|---|
| ref:course:term:cis123 | campus | palmer | |||
| ref:course:term:cis123 | campus | southern | |||
| ref:course:term:cis124 | campus | northern | |||
| ref:course:term:cis124 | termStart | 8/1/2020 (note, this is actually integer seconds since 1970) | |||
| ref:course:term:cis124 | termEnd | 1/1/2020 | |||
| ref:course:term:cis124 | thisTerm | T | |||
Loading attributes to groups
This can use a similar format to the marker / name-value pair convention for attributes, or can just be attributes on groups. i.e. the marker attribute column is optional. Types will be converted (e.g. the varchar "24" will be converted to 24 if the attribute is integer based). Note: dates can be converted to the appropriate type (e.g. from date column to integer seconds from 1970)
| SQL query with columns, eventually a loader job | |||||
| Group name | Attribute marker name | Attribute name | Attribute value | Active | Next start time |
|---|---|---|---|---|---|
| ref:course:term:cis123 | etc:attribute:mySchool:course:course | etc:attribute:mySchool:course:campus | palmer | ||
| ref:course:term:cis123 | etc:attribute:mySchool:course:course | etc:attribute:mySchool:course:campus | southern | ||
| ref:course:term:cis124 | etc:attribute:mySchool:course:termStart | etc:attribute:mySchool:course:termStart | 8/1/2020 | ||
Subject attribute table
The individual attribute values are fed from basis/ref groups and the values can be transformed from the group name to something that has institutional meaning. This can happen from attribute or from text manipulation
| grouper_abac_subject_attributes | ||||||
| Subject id | Source id | Attribute name | Attribute value | Active | Next start time | Last end time |
|---|---|---|---|---|---|---|
| jsmith | person | affiliation | staff | T | ||
| jsmith | person | dept | math | T | ||
| jsmith | person | dept | physics | T | ||
| rjohnson | person | school | engineering | F | 11/1/2020 | |
| wturner | person | primaryAffiliation | faculty | T | ||
Group somewhere in registry has a GraphQL or some other type expression. Boolean logic and wildcards are required
| Group | Type | Expression | Description |
|---|---|---|---|
| org:whatever:app:somePolicy | ref/bassis groups as members | (groups(campus in ['palmer', southern'] and termStart - 7 > sysdate and termEnd + 7 < sysdate)) | Give me groups as members where campus and term match |
| org:whatever2:app2:somePolicy2 | subjects as members | (subjects(primaryAffiliation in ['faculty', 'staff'] and dept in ['physics', 'math'])) | Subjects in a role and dept |
| org:whatever3:app3:somePolicy3 | could have some groups and subjects | (groups(campus in ['palmer', southern'] and termStart - 7 > sysdate and termEnd + 7 < sysdate) or subjects(primaryAffiliation in ['faculty', 'staff'] and dept in ['physics', 'math']))) | Take some group populations and substract out some subject |
The expression can only be written by people who can READ groups in the abac group/subject tables.
A nightly full sync will occur.
An incremental change log consumer can see which memberships change (or attribute values) and which policies those refer to, and incrementally adjust the membership of those groups.