Roberta Marton created TRAFODION-3195:
-----------------------------------------
Summary: 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
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)
