[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
Van Halbert (Moved) (JIRA)
jira-events at lists.jboss.org
Mon Oct 24 13:34:45 EDT 2011
[ https://issues.jboss.org/browse/TEIID-1793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Van Halbert moved SOA-3519 to TEIID-1793:
-----------------------------------------
Project: Teiid (was: JBoss Enterprise SOA Platform)
Key: TEIID-1793 (was: SOA-3519)
Affects Version/s: 7.4.1
(was: 5.2.0.ER3)
Component/s: Server
(was: EDS)
Security: (was: Public)
> 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: Van Halbert
>
> 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
More information about the teiid-issues
mailing list