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

Navis commented on HIVE-6122:
-----------------------------

With this patch, principal_specification is now optional. For example, "SHOW 
GRANT ON TABLE x" returns all principals allowed any of privileges on the table 
X. Furthermore, 'ON' can take 'ALL' keyword representing any resources of any 
type. The above spec should be changed to something like,
{code}
SHOW GRANT [
  principal_specification |
  ON object_type priv_level [(column_list)] |
  ON ALL
]
{code}

Could you translate this as a proper documentation? I tried, but you know --;;

> 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
>              Labels: TODOC13
>             Fix For: 0.13.0
>
>         Attachments: HIVE-6122.1.patch.txt, HIVE-6122.2.patch.txt, 
> HIVE-6122.3.patch.txt, HIVE-6122.4.patch, HIVE-6122.4.patch, 
> HIVE-6122.5.patch, HIVE-6122.6.patch
>
>
> 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.2#6252)

Reply via email to