[ 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