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 Environment: Fedora 14, SOA-P 5.2 ER3 Reporter: Paul Nittel Assignee: Steven Hawkins 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.)

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 Environment: Fedora 14, SOA-P 5.2 ER3 Reporter: Paul Nittel Assignee: Steven Hawkins Priority: Critical 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.)

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.)

hasROLE(rolename) function always returns false ----------------------------------------------- Key: TEIID-1747 URL: https://issues.jboss.org/browse/TEIID-1747 Project: Teiid Issue Type: Bug Components: Documentation, 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.)

hasROLE(rolename) function always returns false ----------------------------------------------- Key: TEIID-1747 URL: https://issues.jboss.org/browse/TEIID-1747 Project: Teiid Issue Type: Bug Components: Documentation, Query Engine Affects Versions: 7.4.1 Environment: Fedora 14, SOA-P 5.2 ER3 Reporter: Paul Nittel Assignee: Steven Hawkins Priority: Minor Fix For: 7.4.1, 7.6 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.)