Bug 781033 (SOA-3517) - 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
Summary: Receive " User <user@teiid-security> is not entitled to action <READ> for 1 o...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-3517
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.2.0.ER3
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.2.0.ER6
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-10-24 16:52 UTC by dsteigne
Modified: 2011-10-31 15:27 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-10-31 15:27:56 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-3517 0 Major Closed Receive " User <user@teiid-security> is not entitled to action <READ> for 1 or more of the groups/elements/procedures." ... 2020-12-04 20:43:08 UTC
Red Hat Issue Tracker TEIID-1793 0 Major Closed Receive " User <user@teiid-security> is not entitled to action <READ> for 1 or more of the groups/elements/procedures." ... 2020-12-04 20:42:40 UTC

Description dsteigne 2011-10-24 16:52:09 UTC 
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A0000008Sz8a
project_key: SOA

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.
Comment 1 Van Halbert 2011-10-24 17:32:35 UTC 
Link: Added: This issue Cloned to SOA-3519
Comment 3 Paul Nittel 2011-10-31 15:27:56 UTC 
Tested and closed.
Note You need to log in before you can comment on or make changes to this bug.