[TRAFODION-2176] a user grant component privilege to another user with by clause got error if the user in by clause is the grantor itself

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql-security
• Assignee: Roberta Marton
• Reporter: Gao, Rui-Xian
• Created: 23/Aug/16 15:46
• Updated: 23/Aug/16 15:46

Description

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.