[teiid-issues] [JBoss JIRA] (TEIID-3354) AdminConsole fails getting mat view info with data roles

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3354:
---------------------------------------

The information in the matview table that is not currently public is:

Valid boolean,
LoadState string(255),
Updated timestamp,
Cardinality integer,

I'm not sure that any of that would qualify as sensitive.  I think the intent behind putting the table in SYSADMIN to begin with was if additional details about the source table were exposed that wasn't necessarily data that a general user should have.  For now I think a valid resolution would be to move the table into SYS, or to add a specific permission override, and then if needed later add row filtering based upon what the user can actually see (which is something that we could do more generally on other system tables as well).

> AdminConsole fails getting mat view info with data roles
> --------------------------------------------------------
>
>                 Key: TEIID-3354
>                 URL: https://issues.jboss.org/browse/TEIID-3354
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> Once data roles are enable the web console fails to get the mat view info - unless the user allows access to systemadmin for the admin user.
> I'm logging this initially against the Teiid side as depending on the resolution we may want to change the admin code (for example using a SYS.table).



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)