[TRAFODION-1758] A user has dbroot role can't grant component privilege to other users/roles

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql-security
• Assignee: Roberta Marton
• Reporter: Gao, Rui-Xian
• Created: 15/Jan/16 01:29
• Updated: 01/Feb/17 20:01
• Resolved: 01/Feb/17 20:01

Description

A user has dbroot role can't grant component privilege to other users/roles

Reproduce steps –

User DBROOT –

create role myrole1;
register component myusers1;
create component privilege created as 'cr' on myusers1 detail 'create users';
create table t2(a int, b int);
grant role DB__rootrole to testuser1 ;

User testuser1 –

qi_mxci2>grant component privilege created on myusers1 to myrole1 with grant option;

• • • ERROR[1017] You are not authorized to perform this operation. [2015-12-31 15:07:32]

Issue Links

• links to: GitHub Pull Request #765