[
https://issues.apache.org/jira/browse/HIVE-6122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13883219#comment-13883219
]
Ashutosh Chauhan commented on HIVE-6122:
----------------------------------------
Thinking more on this, I think its fine to have this syntax, since this part of
syntax is not part of standard anyways. Also, I mistakenly thought patch is
introducing new keyword 'ALL' but 'ALL' is already a keyword both in Hive and
in standard, so we should be good there.
+1
> Implement show grant on <resource>
> ----------------------------------
>
> Key: HIVE-6122
> URL: https://issues.apache.org/jira/browse/HIVE-6122
> Project: Hive
> Issue Type: Improvement
> Components: Authorization
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-6122.1.patch.txt, HIVE-6122.2.patch.txt,
> HIVE-6122.3.patch.txt
>
>
> Currently, hive shows privileges owned by a principal. Reverse API is also
> needed, which shows all principals for a resource.
> {noformat}
> show grant user hive_test_user on database default;
> show grant user hive_test_user on table dummy;
> show grant user hive_test_user on all;
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
