Bug 1041878

Summary:	[RFE][keystone]: Rationalize the 4 SQL grant tables into one assignment table
Product:	Red Hat OpenStack	Reporter:	RHOS Integration <rhos-integ>
Component:	RFEs	Assignee:	RHOS Maint <rhos-maint>
Status:	CLOSED UPSTREAM	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	unspecified	CC:	markmc, yeylon
Target Milestone:	---	Keywords:	FutureFeature
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
URL:	https://blueprints.launchpad.net/keystone/+spec/grant-table-rationalization
Whiteboard:	upstream_milestone_none upstream_status_started upstream_definition_superseded
Fixed In Version:		Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-03-19 16:54:47 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description RHOS Integration 2013-12-12 19:50:56 UTC

Cloned from launchpad blueprint https://blueprints.launchpad.net/keystone/+spec/grant-table-rationalization.

Description:

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.

Specification URL (additional information):

None