<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">
<pre>Hi dejan,</pre>
<pre><tt>I guess you are looking to set a default role at the schema level:</tt></pre>
<pre><Schema name="my_schema" defaultRole="role_ABC"></pre>
<pre>[...]
        <Role name="role_ABC">
         <SchemaGrant access="none">
         </SchemaGrant>
        </Role>
</Schema></pre>
<pre>BR,</pre>
<pre>Ricardo Fradinho</pre>
<font face="Arial"><br>
On 12/11/2013 12:30 , Dejan Gambin wrote:</font><br>
</div>
<blockquote cite="mid:78CF13C9-A9A1-4902-B9B8-661326076502@coin.hr"
type="cite">
<pre wrap="">Hi,
I am using user-session role mapper to map session attribute taken from database table to mondrian role. The problem is (using Saiku) - if user mondrian role is not defined in schema, this user can see all the cubes in the schema, by default. I have made a test with one2one role mapper and the behaviour is the opposite (and correct I suppose) - the user can't see any cube in schema if his role is not defined in this schema.
I would just like to know if this is supposed to be so and do I have to make some workarounds - I am thinking about defining the session variable as an array (now it is a string) and give all the users additional role, for example "none" and define something like this in all of my schemas:
        <Role name="none">
         <SchemaGrant access="none">
         </SchemaGrant>
        </Role>
I think this is much simpler than defining all the roles in all schemas :-)
Btw, I am using mondrian from saiku 2.6, I think the version is 3.6
Thanks very much on any useful information
regards, dejan
_______________________________________________
Mondrian mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a>
<a class="moz-txt-link-freetext" href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a>
</pre>
</blockquote>
<br>
</body>
</html>