You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (JIRA)" <ji...@apache.org> on 2011/02/04 21:19:30 UTC
[jira] Updated: (HIVE-1928) GRANT/REVOKE should handle privileges
as tokens, not identifiers
[ https://issues.apache.org/jira/browse/HIVE-1928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1928:
---------------------------------
Priority: Critical (was: Blocker)
Downgrading to critical.
> 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: Critical
> Fix For: 0.7.0
>
>
> 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