[RANGER-1696] Request to get all policies for hive or hbase service-type does not include policies that apply to specific child resource(such as table in hive/column family in hbase)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: master
• Fix Version/s: 1.0.0, master, 0.7.2
• Component/s: Ranger
• Assignee: Abhay Kulkarni
• Reporter: Deepak Sharma
• Created: 17/Jul/17 23:46
• Updated: 25/Jul/17 02:38
• Resolved: 25/Jul/17 02:38

Description

Scenario:
Consider the following set of Ranger policies.

policy_name                             Database       Table               Column
policy_for_all_resource            *                       *                      *
policy_for_testdb1                    testdb1            *                      *
policy_for_testdb1-testtable1   testdb1            testtable1        *
policy_for_testcol-testtable1    testdb1            testtable1        testcol

The following REST API call to get all policies for database 'testdb1',
http://<ranger-admin-ip>:6080/service/public/v2/api/policies/hive/for-resource?resource:database=testdb1
,is expected to return all above policies. However, 'policy_for_testdb1-testtable1' and 'policy_for_testcol-testtable1' are not returned.