[jira] [Created] (TRAFODION-768) LP Bug: 1392805 - DB__ROOT incorrectly gets "NOT AUTHORIZED" messages

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

Alice Chen created TRAFODION-768:
------------------------------------

             Summary: LP Bug: 1392805 - DB__ROOT incorrectly gets "NOT AUTHORIZED" messages
                 Key: TRAFODION-768
                 URL: https://issues.apache.org/jira/browse/TRAFODION-768
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Paul Low
            Assignee: Roberta Marton
            Priority: Critical
             Fix For: 1.0 (pre-incubation)


DB__ROOT is returned an error when trying to create a table referencing another table.

User creates schema and table.
DB__ROOT has no issues creating a regular table without references.
DB__ROOT tries to create table on the schema with reference to the user's table.  DB__ROOT should be able to do this operation, but an error is returned instead.

Logged in as DB__ROOT ...

SQL>set schema sch16;

--- SQL operation complete.

SQL>showddl tabri16;

 
CREATE TABLE TRAFODION.SCH16.TABRI16
  ( 
    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , PRIMARY KEY (A ASC)
  )
;
 
-- GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TRAFODION.SCH16.TABRI16 TO USERNAME1 WITH GRANT OPTION;

--- SQL operation complete.

SQL>create table tabridbroot (c int, b int not null, constraint fk foreign key (b) references tabri16) no partition;

*** ERROR[1017] You are not authorized to perform this operation.
*** ERROR[1029] Object TRAFODION.SCH16.TABRIDBROOT could not be created.

SQL>



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