[jira] [Updated] (TRAFODION-640) LP Bug: 1370754 - Objects with delimited names not displayed correctly for SHOWDDL

["Hans Zeller (JIRA)" <ji...@apache.org>]

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

Hans Zeller updated TRAFODION-640:
----------------------------------
    Fix Version/s:     (was: 2.0-incubating)
                   2.1-incubating

> LP Bug: 1370754 - Objects with delimited names not displayed correctly for SHOWDDL
> ----------------------------------------------------------------------------------
>
>                 Key: TRAFODION-640
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-640
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-security
>            Reporter: Roberta Marton
>            Assignee: Roberta Marton
>            Priority: Minor
>             Fix For: 2.1-incubating
>
>
> When objects are created, a set of default privileges are granted by the system to the creator.  Later when SHOWDDL is executed, associated grants are returned.  The initial grants to the owner for delimited names are not stored correctly.
> create table "my-schema"."my-table" (c1 int not null primary key, c2 int);
> grant select on "my-schema"."my-table" to sql_user1;
> showddl "my-schema"."my-table";
> CREATE TABLE TRAFODION."my-schema"."my-table"
>   (
>     C1                               INT NO DEFAULT NOT NULL NOT DROPPABLE
>   , C2                               INT DEFAULT NULL
>   , PRIMARY KEY (C1 ASC)
>   )
> ;
> -- GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TRAFODION.my-schema.my-table TO DB__ROOT WITH GRANT OPTION;
>   GRANT SELECT ON TRAFODION."my-schema"."my-table" TO SQL_USER1;
> Since it is only happening on the owner grants, this is just cosmetic:
> drop table "my-schema"."my-table";
>  
> --> recreate of table using SHOWDDL output does succeed:
> CREATE TABLE TRAFODION."my-schema"."my-table"
>   (
>     C1                               INT NO DEFAULT NOT NULL NOT DROPPABLE
>   , C2                               INT DEFAULT NULL
>   , PRIMARY KEY (C1 ASC)
>   )
> ;
> -- GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TRAFODION.my-schema.my-table TO DB__ROOT WITH GRANT OPTION;
>   GRANT SELECT ON TRAFODION."my-schema"."my-table" TO SQL_USER1;



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