[
https://issues.apache.org/jira/browse/SENTRY-2220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16468839#comment-16468839
]
Arjun Mishra commented on SENTRY-2220:
--------------------------------------
[~LinaAtAustin] We're not adding a new syntax but supporting what already
exists in Hive. Currently Sentry doesn't support it. I specifically want to
cover this show grant command
{noformat}
Find out the privileges all users have on table hivejiratable:
0: jdbc:hive2://localhost:10000> show grant on table hivejiratable;
+-----------+----------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
| database | table | partition | column | principal_name |
principal_type | privilege | grant_option | grant_time | grantor |
+-----------+----------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
| default | hivejiratable | | | ashutosh | USER
| DELETE | false | 1398303419000 | thejas |
| default | hivejiratable | | | ashutosh | USER
| SELECT | false | 1398303407000 | thejas |
| default | hivejiratable | | | navis | USER
| INSERT | false | 1398303650000 | thejas |
| default | hivejiratable | | | navis | USER
| SELECT | false | 1398303650000 | thejas |
| default | hivejiratable | | | public | ROLE
| SELECT | false | 1398303481000 | thejas |
| default | hivejiratable | | | thejas | USER
| DELETE | true | 1398303380000 | thejas |
| default | hivejiratable | | | thejas | USER
| INSERT | true | 1398303380000 | thejas |
| default | hivejiratable | | | thejas | USER
| SELECT | true | 1398303380000 | thejas |
| default | hivejiratable | | | thejas | USER
| UPDATE | true | 1398303380000 | thejas |
+-----------+----------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
{noformat}
> Support SHOW GRANT on Hive Object
> ---------------------------------
>
> Key: SENTRY-2220
> URL: https://issues.apache.org/jira/browse/SENTRY-2220
> Project: Sentry
> Issue Type: New Feature
> Components: Sentry
> Affects Versions: 2.1.0
> Reporter: Arjun Mishra
> Assignee: Arjun Mishra
> Priority: Major
> Fix For: 2.1.0
>
>
> Currently sentry doesn't support show grant <hive_object> command. This
> feature aims to address that
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
