[teiid-issues] [JBoss JIRA] (TEIID-1793) Receive " User <user@teiid-security> is not entitled to action <READ> for 1 or more of the groups/elements/procedures." error on unqualified SQL if data roles are active

Receive " User <user@teiid-security> is not entitled to action <READ> for 1 or more of the groups/elements/procedures." error on unqualified SQL if data roles are active ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Key: TEIID-1793 URL: https://issues.jboss.org/browse/TEIID-1793 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 7.4.1 Reporter: Debbie Steigner Assignee: Steven Hawkins Fix For: 7.4.1, 7.6 If you run a query 'SELECT * FROM MyProc' i.e. without a model/schema name, You'll receive the below error if an all Access Data Role is assigned to the VDB. If you remove the Data Role, the query succeeds. Error: Remote org.teiid.api.exception.query.QueryValidatorException: User <user@teiid-security> is not entitled to action <READ> for 1 or more of the groups/elements/procedures. SQLState: 50000 ErrorCode: 0 The query only succeeds if you fully qualify the proc/table when Data Roles are used.