[jira] [Updated] (SENTRY-593) show role grants against object

["Prasad Mujumdar (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SENTRY-593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Prasad Mujumdar updated SENTRY-593:
-----------------------------------
    Assignee: Johndee Burks

> 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
(v6.3.4#6332)