Unified SQL table for role assignments
As discussed at the Icehouse summit [1], we desperately need to merge the various role assignment tables into a single table that can be queried more efficiently for the data we actually need, such as... roles!
Roles are currently persisted as JSON in a metadata column, and assignments are spread across 4 different tables (user-project, group-project, user-domain, group-domain). These four tables should be migrated to one unified table described here [2].
[1]: http://
[2]: https:/
Blueprint information
- Status:
- Complete
- Approver:
- None
- Priority:
- Medium
- Drafter:
- None
- Direction:
- Needs approval
- Assignee:
- Henry Nash
- Definition:
- Approved
- Series goal:
- Accepted for icehouse
- Implementation:
- Implemented
- Milestone target:
- 2014.1
- Started by
- Henry Nash
- Completed by
- Dolph Mathews
Related branches
Related bugs
Sprints
Whiteboard
Gerrit topic: https:/
Addressed by: https:/
Rationalize the Assignment Grant Tables
Work Items
Dependency tree
* Blueprints in grey have been implemented.