[
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)
