You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Roberta Marton (JIRA)" <ji...@apache.org> on 2018/10/01 16:13:00 UTC
[jira] [Resolved] (TRAFODION-3195) Get schemas for role and get
schemas for user working incorrectly
[ https://issues.apache.org/jira/browse/TRAFODION-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Roberta Marton resolved TRAFODION-3195.
---------------------------------------
Resolution: Fixed
> Get schemas for role and get schemas for user working incorrectly
> -----------------------------------------------------------------
>
> Key: TRAFODION-3195
> URL: https://issues.apache.org/jira/browse/TRAFODION-3195
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Roberta Marton
> Assignee: Roberta Marton
> Priority: Major
>
> Various issues with get schema for <authtype> <authid> command:
> * Get schemas for role is reporting incorrect heading (User instead of Role)
> ** create schema abc authorization db__rootrole;
> ** get schemas for role db__rootrole;
> ** Schemas for User DB__ROOTROLE
> * get schemas for role <userid> returns schemas owned by userID
> * get schemas for user <roleid> returns schemas owned by roleID
> * Privilege checks missing on get schema for role and get schema for user commands
> ** revoke component privilege "SHOW" on sql_operations from "PUBLIC"
> ** sqlci -u sql_user1
> ** get schemas for role db__rootrole -> returns schemas that sql_user1 has no privs
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)