Showddl after granting privs on metadata tables fails
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Released
|
High
|
Roberta Marton |
Bug Description
The showddl statement for tables should show all the granted privileges.
After the select priv is granted on a system metadata table followed by a showddl, the showddl does not show any privileges.
sqlci
Trafodion Conversational Interface 1.0.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>grant select on "_MD_".keys to sql_user2;
--- SQL operation complete.
>>showddl "_MD_".keys;
CREATE TABLE TRAFODION.
(
OBJECT_UID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
, COLUMN_NAME VARCHAR(256 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, KEYSEQ_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE
, COLUMN_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE
, ORDERING INT NO DEFAULT NOT NULL NOT DROPPABLE
, NONKEYCOL INT NO DEFAULT NOT NULL NOT DROPPABLE
, FLAGS LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
, PRIMARY KEY (OBJECT_UID ASC, KEYSEQ_NUMBER ASC)
)
;
--- SQL operation complete.
>>
If you exit out of sqlci and rerun the showddl command, it now shows all the privileges.
>exit
sqlci
>>showddl "_MD_".keys;
CREATE TABLE TRAFODION.
(
OBJECT_UID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
, COLUMN_NAME VARCHAR(256 BYTES) CHARACTER SET UTF8
COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, KEYSEQ_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE
, COLUMN_NUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE
, ORDERING INT NO DEFAULT NOT NULL NOT DROPPABLE
, NONKEYCOL INT NO DEFAULT NOT NULL NOT DROPPABLE
, FLAGS LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
, PRIMARY KEY (OBJECT_UID ASC, KEYSEQ_NUMBER ASC)
)
;
-- GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TRAFODION.
GRANT SELECT ON TRAFODION.
GRANT SELECT ON
TRAFODION.
--- SQL operation complete.
Changed in trafodion: | |
assignee: | nobody → Roberta Marton (roberta-marton) |
importance: | Undecided → High |
milestone: | none → r1.1 |
tags: | added: sql-cmu |
Changed in trafodion: | |
status: | New → In Progress |
tags: |
added: sql-security removed: sql-cmu |
fixed