sentry-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Moist (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SENTRY-593) show role grants against object
Date Fri, 16 Feb 2018 17:06:00 GMT

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

Mime
View raw message