[RANGER-1459] Ranger update policy API is failing on Postgres / Oracle for case sensitive ACLs

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.7.1
• Component/s: admin
• Assignee: Gautam Borad
• Reporter: Mehul Parikh
• Created: 15/Mar/17 15:00
• Updated: 16/Mar/17 16:36
• Resolved: 16/Mar/17 16:36

Description

When user tries to disable a ranger policy via REST API with postgres DB, then it gives this error, it works on MySQL though :

{u'msgDesc': u"Create: is not a valid access-type. policy='cl1_hive-87808627-ac26-499a-bea8-e99677a41889' service='cl1_hive'", u'statusCode': 1}

Mainly : This is a case sensitive issue on postgres / Oracle for ACLs, need to keep it consistent for GET and PUT calls for policies.