[ 
https://issues.apache.org/jira/browse/HIVE-6122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13878168#comment-13878168
 ] 

Ashutosh Chauhan commented on HIVE-6122:
----------------------------------------

Few questions:
1. Instead of 
> show grant user hive_test_user on all;
another alternative is not to introduce new keyword/token and instead if user 
doesn't specify resource, show grants for all resources, ie
> show grant user hive_test_user;
We can further cut down this to:
> show grant; 
Above will show all grants for current user.

2. Also does this patch work for roles as well, ie
> show grant role hive_test_role; 


> 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)

Reply via email to