[jira] [Created] (TRAFODION-937) LP Bug: 1413760 - Component privilege create_table does not include create table like

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

Alice Chen created TRAFODION-937:
------------------------------------

             Summary: LP Bug: 1413760 - Component privilege create_table does not include create table like
                 Key: TRAFODION-937
                 URL: https://issues.apache.org/jira/browse/TRAFODION-937
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Paul Low
            Assignee: Cliff Gray
             Fix For: 1.1 (pre-incubation)


User granted component privilege create_table is able to execute 'create table', but 'create table like' fails.  ERROR[1230] is returned unexpectedly to the user.  Users not granted the component privilege had ERROR[1017] returned as expected.  See log below.

SQL>

SQL>create schema sch11;

--- SQL operation complete.

SQL>set schema sch11;

--- SQL operation complete.

SQL>create table tab1(a int, b int);            

--- SQL operation complete.

SQL>grant component privilege create_table on sql_operations to USERNAME61;

--- SQL operation complete.

SQL>connect USERNAME62/PASSWORD62
Connected to Trafodion 

SQL>set schema sch11;

--- SQL operation complete.

SQL>create table tab62 like tab1;

*** ERROR[1017] You are not authorized to perform this operation. 

SQL>create table tab62(a int, b int);

*** ERROR[1017] You are not authorized to perform this operation.

SQL>connect USERNAME61/PASSWORD61
Connected to Trafodion 

SQL>set schema sch11;

--- SQL operation complete.

SQL>create table tab61 like tab1;

*** ERROR[1230] Object owner must be the schema owner in private schemas.
*** ERROR[8839] Transaction was aborted.

SQL>create table tab61( a int, b int);

--- SQL operation complete.

SQL>connect USERNAME1/PASSWORD1
Connected to Trafodion 

SQL>drop schema sch11 cascade;

--- SQL operation complete.

SQL>revoke component privilege create_table on sql_operations from USERNAME61;

--- SQL operation complete.

SQL>



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