[jira] [Created] (TRAFODION-1806) create view with sequence failed with ERROR[4481] though the user has been granted usage privilege

[Gao, Rui-Xian (JIRA)]

Gao, Rui-Xian created TRAFODION-1806:
----------------------------------------

             Summary: create view with sequence failed with ERROR[4481] though 
the user has been granted usage privilege
                 Key: TRAFODION-1806
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1806
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
    Affects Versions: 2.0-incubating
         Environment: esgynDB: esgynDB-20160107_0900-bin
platform: suse11
            Reporter: Gao, Rui-Xian



create view with sequence failed though the user has been granted usage  
privileges on the sequence, here is the steps to reproduce --

User dbroot--
create schema myschema;
GRANT COMPONENT privilege create_view on sql_operations to testuser1;
 set schema myschema;
create table mytable (a int, b int);
insert into mytable values (1,1);
 create sequence myseq;
 
grant select on  mytable to testuser1;
grant usage on sequence myseq to testuser1;
 
>>showddl sequence myseq;
 
CREATE SEQUENCE TRAFODION.MYSCHEMA.MYSEQ
  START WITH 1 /* NEXT AVAILABLE VALUE 1 */
  INCREMENT BY 1
  MAXVALUE 9223372036854775806
  MINVALUE 1
  CACHE 25
  NO CYCLE
  LARGEINT
;
 
-- GRANT USAGE ON SEQUENCE TRAFODION.MYSCHEMA.MYSEQ TO DB__ROOT WITH GRANT 
OPTION;
  GRANT USAGE ON SEQUENCE TRAFODION.MYSCHEMA.MYSEQ TO TESTUSER1;
user testuser1--
set schema myschema;
create view myview as select seqnum(myseq) as a from mytable;
*** ERROR[4481] The user does not have SELECT privilege on table or view . 




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)