[ https://issues.apache.org/jira/browse/TRAFODION-1758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on TRAFODION-1758 started by Roberta Marton. ------------------------------------------------- > A user has dbroot role can't grant component privilege to other users/roles > --------------------------------------------------------------------------- > > Key: TRAFODION-1758 > URL: https://issues.apache.org/jira/browse/TRAFODION-1758 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-security > Reporter: Gao, Rui-Xian > Assignee: Roberta Marton > > 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] -- This message was sent by Atlassian JIRA (v6.3.4#6332)