[jira] [Assigned] (TRAFODION-1031) LP Bug: 1427871 - "PUBLIC" is not recognized in some statements

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

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

Suresh Subbiah reassigned TRAFODION-1031:
-----------------------------------------

    Assignee: Roberta Marton  (was: Cliff Gray)

> LP Bug: 1427871 - "PUBLIC" is not recognized in some statements
> ---------------------------------------------------------------
>
>                 Key: TRAFODION-1031
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1031
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-security
>            Reporter: Paul Low
>            Assignee: Roberta Marton
>             Fix For: 2.0-incubating
>
>
> 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.



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