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

["Roberta Marton (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Roberta Marton closed TRAFODION-1758.
-------------------------------------
    Resolution: Fixed

> 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.15#6346)