You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ranger.apache.org by "Hanish Bansal (JIRA)" <ji...@apache.org> on 2015/06/11 09:04:00 UTC

[jira] [Created] (RANGER-547) Hive Update privilege behavior

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)