[teiid-issues] [JBoss JIRA] (TEIID-1793) Receive " User <user at 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

[Steven Hawkins (Commented) (JIRA)]

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

Steven Hawkins commented on TEIID-1793:
---------------------------------------

It this ok to check-in for 7.4.1?
                
> Receive " User <user at 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
>
> 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 at 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira