[jira] [Created] (TRAFODION-800) LP Bug: 1398516 - USAGE priv for sequence not working correctly

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-800:
------------------------------------

             Summary: LP Bug: 1398516 - USAGE priv for sequence not working correctly
                 Key: TRAFODION-800
                 URL: https://issues.apache.org/jira/browse/TRAFODION-800
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Paul Low
            Assignee: Barry Fritchman
            Priority: Critical
             Fix For: 1.0 (pre-incubation)


The USAGE privilege is not granted.  The owner cannot use the sequence.  A user granted USAGE privilege cannot access sequence even though the GRANT USAGE command succeeded.

SQL>connect username1/password1;
Connected to Trafodion 

SQL>create table tab11(a int, b int)no partition;

--- SQL operation complete.

SQL>create sequence seq11;

--- SQL operation complete.

SQL>select * from tab11 where a < seqnum(seq11);

*** ERROR[4491] The user does not have USAGE privilege on sequence TRAFODION.SEABASE.SEQ11. 

SQL>grant usage on sequence seq11 to username2;

--- SQL operation complete.

SQL>grant all on table tab11 to username2;

--- SQL operation complete.

SQL>connect username2/password2
Connected to Trafodion 

SQL>select * from tab11 where a < seqnum(seq11);

*** ERROR[4491] The user does not have USAGE privilege on sequence TRAFODION.SEABASE.SEQ11.



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