Hanish Bansal created RANGER-547:
------------------------------------
Summary: Hive Update privilege behavior
Key: RANGER-547
URL: https://issues.apache.org/jira/browse/RANGER-547
Project: Ranger
Issue Type: Bug
Affects Versions: 0.4.0
Reporter: Hanish Bansal
Priority: Minor
For update privileges to a user we have to give Select AND Update both
privilege. Otherwise update privileges don't work.
Steps followed:
1. Create a table "test​" in hive.
2. Give privilege of only update to a user, e.g. john.
3. Make connection in hive with the same user. Run update query on "test" table
- "Update test​ SET first_name='pr' where id=124;"
Expected Behavior - It should update the table
Actual Behavior- Getting exception- "FAILED: HiveAccessControlException
Permission denied: user [john] does not have [SELECT] privilege on
[default/test/id] (state=42000,code=40000)
"
Once providing both privileges 'select' and 'update' to user "john" then it's
working fine.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
