[jira] [Created] (TRAFODION-820) LP Bug: 1401678 - Private schema not working correctly when owned by a role

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

Alice Chen created TRAFODION-820:
------------------------------------

             Summary: LP Bug: 1401678 - Private schema not working correctly when owned by a role
                 Key: TRAFODION-820
                 URL: https://issues.apache.org/jira/browse/TRAFODION-820
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Paul Low
            Assignee: Cliff Gray
            Priority: Critical
             Fix For: 1.0 (pre-incubation)


User is granted role.
Private schema is created with role as owner.
User is able to create table, but unable to create view and a weird error is returned.
User is also unable to drop the table that he created.
User is also unable to drop schema where role is the owner.


SQL>create role role1;

--- SQL operation complete.

SQL>grant role role1 to USERNAME1;

--- SQL operation complete.

SQL>create schema authorization role1;

--- SQL operation complete.

SQL>connect USERNAME1/PASSWORD1
Connected to Trafodion 

SQL>set schema role1;

--- SQL operation complete.

SQL>create table tab1(a int);

--- SQL operation complete.

SQL>create view view1 as select * from tab1;

*** ERROR[1340] ROLE1 is not a user. 
*** ERROR[20235] Error returned while converting user ID to username, status: 11 userid: 1000001.

SQL>drop table tab1;

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

SQL>drop schema role1 cascade;

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

SQL>



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