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
            Priority: Blocker


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.
-
You can reply to this email to add a comment to the issue online.

Reply via email to