[jira] [Updated] (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:all-tabpanel ]

Carl Steinbach updated HIVE-1928:
---------------------------------

    Component/s:     (was: Query Processor)
                 Authorization
    
> 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: Authorization, Security
>    Affects Versions: 0.7.0
>            Reporter: Carl Steinbach
>            Assignee: Jonathan Natkins
>            Priority: Critical
>              Labels: Authorization
>             Fix For: 0.7.0
>
>         Attachments: HIVE-1928.1.patch, HIVE-1928.2.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.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira