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)