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