You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/12/09 22:17:10 UTC
[jira] [Commented] (TRAFODION-1031) LP Bug: 1427871 - "PUBLIC" is
not recognized in some statements
[ https://issues.apache.org/jira/browse/TRAFODION-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15049391#comment-15049391 ]
ASF GitHub Bot commented on TRAFODION-1031:
-------------------------------------------
GitHub user robertamarton opened a pull request:
https://github.com/apache/incubator-trafodion/pull/220
TRAFODION-1031: "PUBLIC" is not recognized in some statements
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/robertamarton/incubator-trafodion t-1031
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/220.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #220
----
commit 19a95cd836de4bb51ff03ea6f3d30dd02637c3dd
Author: Roberta Marton <ro...@esgyn.com>
Date: 2015-12-09T21:13:48Z
TRAFODION-1031: PUBLIC" is not recognized in some statements
Fixed a couple of issues where PUBLIC was not returned. With this check-in we
will treat PUBLIC as a special role.
----
> 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)