[TRAFODION-2795] get indexes command fails even though user has privileges to view indexes

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: sql-security
• Assignee: Unassigned
• Reporter: Roberta Marton
• Created: 03/Nov/17 19:27
• Updated: 03/Nov/17 19:27

Description

Performing a SHOWDDL INDEX <index> for a user that has privileges to view the parent table cannot the table's indexes.

as user with create_schema privilege:
create schema sch1;
set schema sch1;
create table t1 (a int, b int, c int);
create index ndx1 on t1(b);
grant select on t1 to sql_user1;

as sql_user1:
set schema sch1;
get tables; - returns t1
get indexes; - should return ndx1 but returns nothing