[
https://issues.apache.org/jira/browse/SENTRY-593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16367591#comment-16367591
]
Steve Moist commented on SENTRY-593:
------------------------------------
Hi all, is this the same as SENTRY-1242?
> show role grants against object
> --------------------------------
>
> Key: SENTRY-593
> URL: https://issues.apache.org/jira/browse/SENTRY-593
> Project: Sentry
> Issue Type: Improvement
> Reporter: Johndee Burks
> Assignee: Johndee Burks
> Priority: Minor
>
> It would be nice to have a command that would show all roles that have grants
> against a particular object. For example if I do the following commands.
> {code}
> grant select on table j1 to role analyst;
> grant select on table j1 to role analyst1;
> grant select on table j1 to role analyst2;
> {code}
> I would like to do something like this:
> {code}
> show grant roles on table j1;
> {code}
> and then it displays something like this:
> {code}
> +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------------+----------+
> | database | table | partition | column | principal_name |
> principal_type | privilege | grant_option | grant_time | grantor |
> +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------------+----------+
> | default | j1 | | | analyst | ROLE
> | select | false | 1416861983065000 | hive |
> | default | j1 | | | analyst1 | ROLE
> | select | false | 1416861983065000 | hive |
> | default | j1 | | | analyst2 | ROLE
> | select | false | 1416861983065000 | hive |
> +-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+-------------------+----------+
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
