[
https://jira.jboss.org/browse/TEIIDDES-609?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIIDDES-609:
---------------------------------------
This may be mute issue after the latest changes to the Teiid to allow by default access to
schema information as these calls are based on "sys" tables.
Teiid QueryValidatorException opening VDB schema in Data Source
Explorer for model with "hidden" table.
-------------------------------------------------------------------------------------------------------
Key: TEIIDDES-609
URL:
https://jira.jboss.org/browse/TEIIDDES-609
Project: Teiid Designer
Issue Type: Bug
Components: VDB & Execution
Affects Versions: 7.1
Reporter: Barry LaFond
Assignee: John Doyle
Priority: Blocker
Fix For: 7.1.1
After creating a data role for PartsSupplier VDB where the CRUD for one table was turned
OFF (i.e. create/read/update/delete = FALSE) and deploying to Teiid, I deployed and
executed the VDB.
But on trying to view the contents in DTP, an exception occured.
org.teiid.jdbc.TeiidSQLException: Error trying to obtain schema metadata info on this
connection: Remote org.teiid.api.exception.query.QueryValidatorException: User
<Hcs7WsIzrd4G> is not entitled to action <Read> for 1 or more of the
groups/elements/procedures..
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:102)
at org.teiid.jdbc.DatabaseMetaDataImpl.getSchemas(DatabaseMetaDataImpl.java:2361)
at org.teiid.jdbc.DatabaseMetaDataImpl.getSchemas(DatabaseMetaDataImpl.java:1298)
at
org.eclipse.datatools.connectivity.sqm.loader.JDBCSchemaLoader.createResultSet(JDBCSchemaLoader.java:174)
at
org.eclipse.datatools.connectivity.sqm.loader.JDBCSchemaLoader.loadSchemas(JDBCSchemaLoader.java:110)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCCatalog.loadSchemas(JDBCCatalog.java:101)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCCatalog.getSchemas(JDBCCatalog.java:64)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.vnode.ServerExplorerVNodeContentProviderNav.displaySchemaNodeChildren(ServerExplorerVNodeContentProviderNav.java:126)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira