Johndee Burks created SENTRY-593:
------------------------------------
Summary: 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
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)
