You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2015/08/22 01:34:45 UTC

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

     [ https://issues.apache.org/jira/browse/TRAFODION-768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Wayne Birdsall closed TRAFODION-768.
------------------------------------------
    Resolution: Fixed

> 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)