OSBI/saiku — Issue #67: Issue with DynamicSchemaProcessor and Roles
Author: dankins
Created: 2011-10-18 12:28:18+00:00
State: open

I have a DynamicSchemaProcessor that creates a role for each user. I also have a Mondrian Role mapper in Pentaho that applies the username as a role to the connection.

It looks like it is definitely running my dynamic schema processor and is applying the correct role, but I think saiku is caching the schema, because when the server boots up I see it creating a schema with but then when i open saiku in PUC I get:
Setting role to datasource:foo role:dan org.olap4j.OlapException: Unknown role 'dan'