[jira] [Assigned] (TRAFODION-1100) LP Bug: 1437470 - Creator of view in private schema unable to select from view

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah reassigned TRAFODION-1100:
-----------------------------------------

    Assignee: Roberta Marton  (was: Cliff Gray)

> LP Bug: 1437470 - Creator of view in private schema unable to select from view
> ------------------------------------------------------------------------------
>
>                 Key: TRAFODION-1100
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1100
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-security
>            Reporter: Paul Low
>            Assignee: Roberta Marton
>            Priority: Critical
>             Fix For: 2.0-incubating
>
>
> Security is enabled on the instance.
> Table and view are created by user on a private schema where he is granted CREATE privilege.
> User is able to select from table, but unable to select from the view that he created.
> According to documentation, the creator of the object is granted full DML privileges on the object they create.
> SQL>select * from myview2;
> *** ERROR[4481] The user does not have SELECT privilege on table or view TRAFODION.SCH001.MYVIEW2.
> See log of sequence below:
> Connected to Trafodion 
> SQL>create schema sch001;
> --- SQL operation complete.
> SQL>grant COMPONENT privilege "CREATE" on sql_operations to username1;
> --- SQL operation complete.
> SQL>connect username1/password1
> Connected to Trafodion 
> SQL>set schema sch001;
> --- SQL operation complete.
> SQL>create table mytable (a int, b int);
> --- SQL operation complete.
> SQL>insert into mytable values (1,1);
> --- 1 row(s) inserted.
> SQL>create view myview2 as select * from mytable;
> --- SQL operation complete.
> SQL>select * from mytable;
> A           B          
> ----------- -----------
>           1           1
> --- 1 row(s) selected.
> SQL>select * from myview2;
> *** ERROR[4481] The user does not have SELECT privilege on table or view TRAFODION.SCH001.MYVIEW2.



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