[teiid-issues] [JBoss JIRA] (TEIID-2476) Exclude hidden tables/columns from metadata

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13164657#comment-13164657 ] 

Ramesh Reddy commented on TEIID-2476:
-------------------------------------

Along these lines few days someone asked me if they could design data roles to prohibit the access to the system tables, as they did not wanted them to be exposed to the client. I know that is separate from this issue, but I can log that.

As per this issue, if we implement at DatabaseMetadata does't that differ with System metadata?

> Exclude hidden tables/columns from metadata
> -------------------------------------------
>
>                 Key: TEIID-2476
>                 URL: https://issues.jboss.org/browse/TEIID-2476
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Driver, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.0
>
>
> We should offer or possibly default to filtering tables/columns that can not accessed out of the user metadata.  This should be done on the server side - however given the reuse we have of the system tables for example for materialized pg catalog queries - it is easier to add filters to the DatabaseMetadata (and ideally pg) metadata queries.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)