Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Access control on cubes with saiku plugin

  1. #1
    Join Date
    May 2012
    Posts
    9

    Default Access control on cubes with saiku plugin

    Hi,

    I work with Pentaho CE with BI Server 3.1 and Saiku plugin 2.2.
    I would like to limit access to my cubes.


    I managed to make it works for jpivot (add xml in acl-files tag in pentaho.xml).

    For Saiku, I updated pentahoObject.spring.xml, by uncommenting

    <bean id="Mondrian-UserRoleMapper"

    name="Mondrian-One-To-One-UserRoleMapper"
    class="org.pentaho.platform.plugin.action.mondrian.mapper.MondrianOneToOneUserRoleListMapper"
    scope="singleton" />

    I also add roles in my cubes with schema workbench.

    But users have still access to all the cubes by Saiku.

    Does someone know how to proceed ?

    Thanks in advance,
    Michele

  2. #2
    Join Date
    Dec 2010
    Posts
    304

    Default

    Hi, I use this bean

    <!--
    This sample mapper assumes that every user has their mondrian roles in their session under then named session variable
    -->
    <bean id="Mondrian-UserRoleMapper"
    name="Mondrian-SampleUserSession-UserRoleMapper"
    class="org.pentaho.platform.plugin.action.mondrian.mapper.MondrianUserSessionUserRoleListMapper"
    scope="singleton">
    <property name="sessionProperty" value="role" />
    </bean>

    role is my session variable containing the Mondrian role.
    I create it in a xaction that runs at startup (see sessionStartupActions.xml)
    As input of my xaction I get the session variable "username" and then I assign the right role to that user.

  3. #3
    Join Date
    Jun 2007
    Posts
    103

    Default

    Hi

    I thought that one could secure the .saiku files based on access rights to the folders that contain them. Is that easier/harder/better/worse than using startup Mondrian roles?

    Thanks
    - rlm

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.