Gao, Rui-Xian created TRAFODION-2177:
----------------------------------------
Summary: 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)
