Rationalize the 4 SQL grant tables into one assignment table

Registered by Henry Nash

The SQL assignment backend uses a separate table for each of the four grant types (UserProject, GroupProject, UserDomain and GroupDomain). In addition, the roles are stored in a list with each grant pair. This leads to code duplication and the inability to do efficient sql generation. We should rationalize these into a single "assignment" table.

Blueprint information

Status:
Complete
Approver:
None
Priority:
Undefined
Drafter:
Henry Nash
Direction:
Needs approval
Assignee:
Henry Nash
Definition:
Superseded
Series goal:
None
Implementation:
Started
Milestone target:
None
Started by
Henry Nash
Completed by
Henry Nash

Related branches

Sprints

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.