[ https://issues.apache.org/jira/browse/HIVE-6122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13879125#comment-13879125 ]
Ashutosh Chauhan commented on HIVE-6122: ---------------------------------------- Are you concerned about backward-compat? That we show all privileges for user with {{ show grant user hive_test_user }} as oppose to only user-level earlier. Than in HIVE-5928 a new plugin api is implemented, so we can make backward incompatible change on new api, instead of modifying behavior for existing syntax of old api. Also, HIVE-5929 has impl of that api. In other words, only with {{ set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory }} {{ show grant user hive_test_user }} will show all privileges for user, otherwise old behavior. > 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)