"PUBLIC" is not recognized in some statements
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
Medium
|
Cliff Gray |
Bug Description
Security is enabled. "PUBLIC" is not recognized as a user or role, but it is mainly used as a role name in some commands.
We should be consistent and be able to use it everywhere and also display it as a role name (or a user name).
Showddl and Get commands do not currently recognize "Public".
SQL>get component privileges on sql_operations for "public";
Privilege information on Component SQL_OPERATIONS for PUBLIC
=======
CREATE_SCHEMA
SHOW
--- SQL operation complete.
SQL>showddl user "PUBLIC";
*** ERROR[1333] User PUBLIC does not exist. [2015-03-03 12:11:54]
SQL>showddl role "PUBLIC";
*** ERROR[1338] Role PUBLIC is not defined in the database. [2015-03-03 10:44:15]
SQL>get roles;
Roles
=====
DB__ROOTROLE
--- SQL operation complete.
SQL>revoke component privilege "SHOW" on sql_operations from "public";
--- SQL operation complete.
Changed in trafodion: | |
status: | New → In Progress |
Changed in trafodion: | |
milestone: | r1.1 → r1.2 |