You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:18:26 UTC
[jira] [Created] (TRAFODION-850) LP Bug: 1405015 - User with select
and insert priv unable to UNLOAD
Alice Chen created TRAFODION-850:
------------------------------------
Summary: LP Bug: 1405015 - User with select and insert priv unable to UNLOAD
Key: TRAFODION-850
URL: https://issues.apache.org/jira/browse/TRAFODION-850
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Paul Low
Assignee: Roberta Marton
Fix For: 1.1 (pre-incubation)
The following error is returned when a user (granted SELECT and INSERT on tables) is unable to UNLOAD.
*** ERROR[4082] Object TRAFODION.SCHEMA1.DUMMY does not exist or is inaccessible
User1 creates a shared schema and two tables. User1 is able to perform LOAD and UNLOAD.
User1 grants SELECT and INSERT privileges on both tables to User2.
User2 is able to LOAD, but UNLOAD fails.
See log below:
Connected to Trafodion
SQL>create shared schema schema1;
--- SQL operation complete.
SQL>set schema schema1;
--- SQL operation complete.
SQL>create table tab1(a int, b int)no partition;
--- SQL operation complete.
SQL>create table tab2(c int, d int)no partition;
--- SQL operation complete.
SQL>insert into tab1 values(1,2),(4,5);
--- 2 row(s) inserted.
SQL>load into tab2 select * from tab1;
UTIL_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------
Task: LOAD Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: CLEANUP Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: CLEANUP Status: Ended Object: TRAFODION.SCHEMA1.TAB2
Task: DISABLE INDEXE Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: DISABLE INDEXE Status: Ended Object: TRAFODION.SCHEMA1.TAB2
Task: PREPARATION Status: Started Object: TRAFODION.SCHEMA1.TAB2
Rows Processed: 2
Task: PREPARATION Status: Ended ET: 00:00:00.788
Task: COMPLETION Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: COMPLETION Status: Ended ET: 00:00:00.574
Task: POPULATE INDEX Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: POPULATE INDEX Status: Ended ET: 00:00:01.656
--- SQL operation complete.
SQL>unload with purgedata from target into '/bulkload/4security' select * from tab2;
UTIL_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
Task: EMPTY TARGET Status: Ended ET: 00:00:00.005
Task: EXTRACT Status: Started
Rows Processed: 2
Task: EXTRACT Status: Ended ET: 00:00:00.717
--- 5 row(s) unloaded.
SQL>grant select, insert on tab1 to USERNAME2;
--- SQL operation complete.
SQL>grant select, insert on tab2 to USERNAME2;
--- SQL operation complete.
SQL>connect USERNAME2/PASSWORD2;
Connected to Trafodion
SQL>set schema schema1;
--- SQL operation complete.
SQL>load into tab2 select * from tab1;
UTIL_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------
Task: LOAD Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: CLEANUP Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: CLEANUP Status: Ended Object: TRAFODION.SCHEMA1.TAB2
Task: DISABLE INDEXE Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: DISABLE INDEXE Status: Ended Object: TRAFODION.SCHEMA1.TAB2
Task: PREPARATION Status: Started Object: TRAFODION.SCHEMA1.TAB2
Rows Processed: 2
Task: PREPARATION Status: Ended ET: 00:00:01.047
Task: COMPLETION Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: COMPLETION Status: Ended ET: 00:00:00.764
Task: POPULATE INDEX Status: Started Object: TRAFODION.SCHEMA1.TAB2
Task: POPULATE INDEX Status: Ended ET: 00:00:01.784
--- SQL operation complete.
SQL>unload with purgedata from target into '/bulkload/4security' select * from tab2;
*** ERROR[4082] Object TRAFODION.SCHEMA1.DUMMY does not exist or is inaccessible.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)