[SENTRY-214] Sentry Service does not allow the same Privilege to be associated to multiple Roles

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: db_policy_store, 1.4.0
• Fix Version/s: 1.4.0
• Assignee: Arun Suresh
• Reporter: Arun Suresh
• Created: 16/May/14 22:57
• Updated: 19/May/14 22:21
• Resolved: 19/May/14 22:21

Description

Steps to recreate :

1) Create role1
2) Create role2
3) Grant 'role1' a Privilege(ALL) to a Table t1, Db d1, server S1
4) the 'listPrivilegesByRoleName' API applied to 'role1' returns a set of size 1
5) Grant 'role2' the same Privilege as role 1.. a Privilege(ALL) to a Table t1, Db d1, server S1
6) the 'listPrivilegesByRoleName' API applied to 'role2' returns a set of size 0