[
https://issues.apache.org/jira/browse/TRAFODION-640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roberta Marton closed TRAFODION-640.
------------------------------------
Resolution: Fixed
The showddl output does show delimited names correctly.
> 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.4.14#64029)
