[teiid-issues] [JBoss JIRA] Commented: (TEIID-1747) hasROLE(rolename) function always returns false
[
https://issues.jboss.org/browse/TEIID-1747?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1747:
---------------------------------------
I think you are confusing the JAAS group/role name with the data role name. hasRole uses
the data role names as defined in the vdb.
hasROLE(rolename) function always returns false
-----------------------------------------------
Key: TEIID-1747
URL: https://issues.jboss.org/browse/TEIID-1747
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Environment: Fedora 14, SOA-P 5.2 ER3
Reporter: Paul Nittel
Assignee: Steven Hawkins
Priority: Blocker
Fix For: 7.4.1
Attachments: RolesVDB.vdb, teiid-security-roles.properties
Given teiid-security-roles.properties contains user=NoRolesRole and the VDB in use has
data roles defined, when logged into Teiid as user, the following SQL should return true.
SELECT hasROLE('NoRolesRole')
However, it always--AFAICT--returns false.
(Roles are working for this VDB as this user is not able to query certain tables.)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira