[
https://issues.apache.org/jira/browse/SENTRY-1631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16414663#comment-16414663
]
Sergio Peña commented on SENTRY-1631:
-------------------------------------
[~kkalyan] I tested this scenario from beeline but I don't see this issue
there.
{noformat}
0: jdbc:hive2://localhost:10000> grant alter on table t21 to role role1;
No rows affected (0.171 seconds)
0: jdbc:hive2://localhost:10000> show grant role role1;
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
| database | table | partition | column | principal_name | principal_type |
privilege | grant_option | grant_time | grantor |
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
| default | t21 | | | role1 | ROLE | ALTER | false | 1522102871000 | -- |
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
5 rows selected (0.114 seconds) [2/85]
0: jdbc:hive2://localhost:10000> revoke alter on table t21 from role role1;
No rows affected (0.123 seconds)
0: jdbc:hive2://localhost:10000> show grant role role1;
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
| database | table | partition | column | principal_name | principal_type |
privilege | grant_option | grant_time | grantor |
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+
+-----------+--------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+{noformat}
Could it be a different API call that is revoking the privilege correctly?
> Not able to revoke privilege for actions like ALTER/CREATE/DROP
> ---------------------------------------------------------------
>
> Key: SENTRY-1631
> URL: https://issues.apache.org/jira/browse/SENTRY-1631
> Project: Sentry
> Issue Type: Bug
> Components: Sentry
> Reporter: kalyan kumar kalvagadda
> Assignee: kalyan kumar kalvagadda
> Priority: Major
>
> javax.jdo.JDODetachedFieldAccessException is observed when a privilege with
> ALTER/CREATE/DROPis revoked.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
