[
https://issues.apache.org/jira/browse/HIVE-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14071387#comment-14071387
]
Lefty Leverenz commented on HIVE-6305:
--------------------------------------
Another question: If hive.support.quoted.identifiers is set to none, can
back-ticks be used for regular expressions in user & role names? I'll try to
dodge the issue in the doc, for now.
Presumably quoted user/role names can have Unicode characters, since the test's
role name has a space (create role `src Role2`). But the SQL Std Auth doc says
user names are managed outside of Hive, so maybe Unicode doesn't work for them.
And presumably this applies to both SQL standard based and default
authorization, so I updated both docs with identical information:
* [SQL Standard Based Hive Authorization -- Names of Users and Roles |
https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization#SQLStandardBasedHiveAuthorization-NamesofUsersandRoles]
* [Hive Authorization -- Names of Users and Roles |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Authorization#LanguageManualAuthorization-NamesofUsersandRoles]
But if Unicode is permitted in user/role names, then the description of
hive.support.quoted.identifiers should be revised to include them. Or even if
Unicode isn't permitted, the parameter should mention user and role names.
* [Configuration Properties -- hive.support.quoted.identifiers |
https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.support.quoted.identifiers]
> test use of quoted identifiers in user/role names
> -------------------------------------------------
>
> Key: HIVE-6305
> URL: https://issues.apache.org/jira/browse/HIVE-6305
> Project: Hive
> Issue Type: Bug
> Components: Authorization
> Reporter: Thejas M Nair
> Assignee: Jason Dere
> Labels: TODOC13
> Fix For: 0.14.0
>
> Attachments: HIVE-6305.1.patch
>
>
> Tests need to be added to verify that quoted identifiers can be used with
> user and role names.
> For example -
> {code}
> grant all on x to user `user-qa`;
> show grant user `user-qa` on table x;
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
