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