[TRAFODION-2196] column privilege -- a user who has been granted privileges on a table with grant option will get error when he grants column privilges to other users/roles

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: sql-security
• Environment: centos6.7; EsgynDB R2.2 0825daily
• Assignee: Roberta Marton
• Reporter: Gao, Rui-Xian
• Created: 30/Aug/16 08:07
• Updated: 14/Sep/16 00:04
• Resolved: 14/Sep/16 00:04

Description

A user has been granted privileges on a table with grant option will get error when he grants column privilges to other users/roles

Reproduce Steps –

create role role1;
create schema mysch;
set schema mysch;
create table atab1(a int not null primary key, b int, c varchar(10));
grant select,insert ,delete, update ,references(a) on atab1 to testuser1 with grant option;

Connect as testuser1 -

Set schema mysch;
grant select(a,b),insert(a),update(b,c),references(a) on atab1 to role1;

• • • ERROR[1012] No privileges were granted. You lack grant option on the specified privileges. [2016-08-27 17:38:32]