Gao, Rui-Xian created TRAFODION-2176:
----------------------------------------
Summary: a user grant component privilege to another user with by
clause got error if the user in by clause is the grantor itself
Key: TRAFODION-2176
URL: https://issues.apache.org/jira/browse/TRAFODION-2176
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Gao, Rui-Xian
Assignee: Roberta Marton
Priority: Minor
a user grant component privilege to another user with by clause got error if
the user in by clause is the grantor itself.
But the grant will succeed without the by clause.
Reproduce Steps --
create role role1;
create role role2;
register component comp1;
create component privilege created as 'cr' on comp1 ;
create component privilege updated as 'up' on comp1 ;
create component privilege deleted as 'de' on comp1 ;
grant component privilege created ,updated on comp1 to qauser1 with grant
option by db__root;
connect as qauser1:
SQL>grant component privilege updated on comp1 to qauser2 by qauser1;
*** ERROR[1017] You are not authorized to perform this operation. [2016-08-16
08:31:00]
SQL>grant component privilege updated on comp1 to qauser2;
--- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
