"PUBLIC" is not recognized in some statements

Bug #1427871 reported by Paul Low
6
This bug affects 1 person
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.

Tags: sql-security
Cliff Gray (cliff-gray)
Changed in trafodion:
status: New → In Progress
Cliff Gray (cliff-gray)
Changed in trafodion:
milestone: r1.1 → r1.2
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.