[ https://issues.apache.org/jira/browse/HIVE-6122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13878232#comment-13878232 ]
Navis commented on HIVE-6122: ----------------------------- In HiveObjectType class, there are GLOBAL(1), DATABASE(2), TABLE(3), PARTITION(4), COLUMN(5) User level corresponds to "GLOBAL" which is checked when creating databases, etc. > 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)