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

Reply via email to