[SENTRY-209] Empty list returned when calling listPrivilegesByRoleName

• 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 18:50
• Updated: 19/May/14 23:08
• Resolved: 19/May/14 21:12

Description

I tested this on a Mysql backend store.. I assume it would be the case for Postgres and Oracle too.. if the initSchema is called (and Datanucleus auto create is false)

Steps to recreate (Using the thrift RPC client):

1) Create role :
sentryClient.createRole(granter, granterGroups, adminRole);

2) Grant table privilege for role (I grant ALL on 100 tables) :
sentryClient.grantTablePrivilege(granter, granterGroups, adminRole, server, db, "ALL");

3) List all privileges for role :
Set<TSentryPrivilege> listPrivilegesByRoleName = sentryClient.listPrivilegesByRoleName(granter, granterGroups, adminRole);

This returns an empty Set.

Issue Links

• contains: SENTRY-210 Exception Thrown When Trying to grantRoleToGroup