[jira] [Updated] (TRAFODION-2175) a user should only see specific schemas/tables that he has privileges to

["Gao, Rui-Xian (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-2175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gao, Rui-Xian updated TRAFODION-2175:
-------------------------------------
    Environment: 
OS -- centos6.7 , centos7.1 , centos7.2
R2.2 daily build

  was:
OS -- centos6.7 , centos7.1 , centos7.2
esgynDB -- R2.2 daily build


> a user should only see specific schemas/tables that he has privileges to
> ------------------------------------------------------------------------
>
>                 Key: TRAFODION-2175
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2175
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-security
>         Environment: OS -- centos6.7 , centos7.1 , centos7.2
> R2.2 daily build
>            Reporter: Gao, Rui-Xian
>            Assignee: Roberta Marton
>            Priority: Major
>
> we have a requirement that a user should only see the objects that he has privileges to do operations on.
> Current feature is, ‘get schemas’ will return all schemas in the database, and in a private schema created by a user, another user can still see all tables with ‘get tables’, and also can check table’s structure with ‘showddl’.
>  
> If we have many customer data on cloud cluster, we don’t want a customer to view any other customers’ data, we want the customers to be isolated from each other.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)