[teiid-issues] [JBoss JIRA] (TEIID-2695) Unable to use CASE statement in Select
[
https://issues.jboss.org/browse/TEIID-2695?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-2695:
------------------------------------
I added the data role to the VDB (trying with and without any-authenticated=true)
<data-role name="Prices" any-authenticated="true" >
<description>Allow ReadOnly Operations to see pricing</description>
<permission>
<resource-name>Stocks</resource-name>
<allow-read>true</allow-read>
</permission>
<mapped-role-name>prices</mapped-role-name>
</data-role>
And still can't get hasRole('prices') to come back true (tried both queries
below
- SELECT symbol,price, CASE WHEN hasRole('prices') THEN 'Y' Else
'N' END as V From StockPrices
- Select hasRole('prices')
Unable to use CASE statement in Select
--------------------------------------
Key: TEIID-2695
URL: https://issues.jboss.org/browse/TEIID-2695
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
Attachments: portfolio-vdb.xml
Trying to add a <mask> of:
<permission>
<resource-name>Stocks.StockPrices.Price</resource-name>
<mask>CASE WHEN hasRole('prices') THEN Price END</mask>
</permission>
even tried using "= true" just to see
but it it always returns null for Prices.
To test it, I logged in as 'user' using CommandLog vdb and issued:
Select VDB, CASE WHEN hasRole('prices') THEN 'Y' Else 'N' END as
V from TEIID_COMMANDLOG
and 'N' was always returned for column V.
teiid roles file:
# A roles.properties file for use with the UsersRolesLoginModule
# username=role1,role2
portfolio=superuser
viewonly=readonly
user=user,prices
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira