Roberta Marton created TRAFODION-2795:
-----------------------------------------
Summary: get indexes command fails even though user has privileges
to view indexes
Key: TRAFODION-2795
URL: https://issues.apache.org/jira/browse/TRAFODION-2795
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Roberta Marton
Priority: Minor
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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
