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

Sergio Peña commented on SENTRY-593:
------------------------------------

Sounds similiar, It might be a duplicate.

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

Reply via email to