[
https://issues.apache.org/jira/browse/TRAFODION-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15456870#comment-15456870
]
ASF GitHub Bot commented on TRAFODION-2177:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/685
> Revoke combined column privileges from role failed
> --------------------------------------------------
>
> Key: TRAFODION-2177
> URL: https://issues.apache.org/jira/browse/TRAFODION-2177
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-security
> Reporter: Gao, Rui-Xian
> Assignee: Roberta Marton
>
> Revoke combined column privileges from role failed, but revoke the privileges
> seperately would succeed.
> Reproduce Steps --
> create role role1;
> create schema grantsch;
> set schema grantsch;
> create table a03tab1(col1 int, col2 int, col3 varchar(10))no partition;
>
> grant insert(col1,col2), select on a03tab1 to role1;
> SQL>revoke insert(col1,col2), select on a03tab1 from role1;
> *** ERROR[1037] Revoke failed because of a dependent grant between
> authorization ID _SYSTEM and authorization ID DB__ROOT [2016-08-17 10:00:20]
> >>revoke select on a03tab1 from role1;
>
> --- SQL operation complete.
> >>revoke insert(col1,col2) on a03tab1 from role1;
>
> --- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
