You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/31 07:37:02 UTC
[jira] [Closed] (TRAFODION-850) LP Bug: 1405015 - User with select
and insert priv unable to UNLOAD
[ https://issues.apache.org/jira/browse/TRAFODION-850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-850.
------------------------------------
Resolution: Fixed
Close issues in JIRA to reflect status in LaunchPad
> 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)