[jira] Commented: (HIVE-1928) GRANT/REVOKE should handle privileges as tokens, not identifiers

["Carl Steinbach (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12995600#comment-12995600 ] 

Carl Steinbach commented on HIVE-1928:
--------------------------------------

+1. Will commit if tests pass.


> GRANT/REVOKE should handle privileges as tokens, not identifiers
> ----------------------------------------------------------------
>
>                 Key: HIVE-1928
>                 URL: https://issues.apache.org/jira/browse/HIVE-1928
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor, Security
>    Affects Versions: 0.7.0
>            Reporter: Carl Steinbach
>            Assignee: Jonathan Natkins
>            Priority: Critical
>         Attachments: HIVE-1928.1.patch
>
>
> The grammar for the GRANT and REVOKE Privileges statements currently handle the list of privileges as a list of
> identifiers. Since most of the privileges are also keywords in the HQL grammar this requires users
> to individually quote-escape each of the privileges, e.g:
> {code}
> grant `Create` on table authorization_part to user hive_test_user;
> grant `Update` on table authorization_part to user hive_test_user;
> grant `Drop` on table authorization_part to user hive_test_user;
> grant `select` on table src to user hive_test_user;
> {code}
> Both MySQL and the SQL standard treat privileges as tokens. Hive should do the same.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira