Bug 1003015 - Teiid server resolves incorrectly SQL query on VDB with data roles with various permissions
Summary: Teiid server resolves incorrectly SQL query on VDB with data roles with vario...
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-08-30 13:43 UTC by Lucie Fabrikova
Modified: 2013-09-03 18:53 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2013-08-30 18:55:46 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Lucie Fabrikova 2013-08-30 13:43:38 UTC
Description of problem:
Teiid server resolves incorrectly SQL query on VDB with data roles with various permissions

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1. Create new teiid user in teiid-security-users.properties ("user1"), add add him a role in teiid-security-roles.properties ("limited") 
2. In teiid designer, create VDB, add a data role mapped to role "limited". Alter e.g. read permissions to one table in VDB.
3. Create teiid connection profile for default teiid user ("user"). Deploy VDB, execute any query.

Actual results:
User with all permissions cannot access some of tables in VDB. [1]

Expected results:


Additional info:
[1] 15:38:49,059 WARN  [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue10) TEIID30020 Processing exception for request FO76bwVFYmEy.0 'TEIID30492 User <user@teiid-security> is not entitled to action <READ> for 1 or more of the groups/elements/procedures.'. Originally QueryValidatorException Request.java:305. Enable more detailed logging to see the entire stacktrace.

Comment 3 Lucie Fabrikova 2013-08-30 13:57:02 UTC
Yes, I did, but the result was same. (I am not sure, but shouldn't be re-deploy of the VDB sufficient?)

Comment 5 Lucie Fabrikova 2013-08-30 14:59:39 UTC
I see, I was mistaken. It is not a bug.


Note You need to log in before you can comment on or make changes to this bug.