[teiid-issues] [JBoss JIRA] (TEIID-2695) Unable to use CASE statement in Select
Van Halbert (JIRA)
jira-events at lists.jboss.org
Fri Oct 11 12:06:27 EDT 2013
[ https://issues.jboss.org/browse/TEIID-2695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12813536#comment-12813536 ]
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
More information about the teiid-issues
mailing list