Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pentaho default security to JDBC security. How to role mapping with operating permits

  1. #1
    Join Date
    Jul 2014
    Posts
    22

    Question Pentaho default security to JDBC security. How to role mapping with operating permits

    Hi, I'm trying to create a role mapping with operating permits after configure JDBC security.
    The configuration goes well. I can login with users stored on my own security tables.

    My trouble is when i trying to loggin with non Administrator user, this one just can read content.

    I 'have tried to create a role mapping like exists in default User spring.xml but i've no idea where I can do this because everywhere i tried its a fail.

    Anyone knows if i can create a role mapping for JDBC security? and where i can do it?

    I'm using bi server 5.0.1 CE

    thanks a lot
    Constança
    Last edited by Constança; 09-24-2014 at 05:34 AM.

  2. #2
    Join Date
    Jul 2014
    Posts
    22

    Thumbs up

    I have solved the problem

    1- Open biserver-ce/pentaho-solutions/system/applicationContext-pentaho-security-jdbc.xml
    2- Find that code

    Code:
    <util:mapid="jdbcRoleMap"> 
           <entry key="admin"value="Administrator"/>
    </util:map>
    3- Change key value for your Admin Role in your tables

    Code:
    <util:mapid="jdbcRoleMap">
          <entry key="Admin Pentaho"value="Administrator"/>
    </util:map>
    4 - Add your diferents roles in the same map and define operations permisions for every role
    Code:
    <util:map id="jdbcRoleMap">
      <entry key="Admin Pentaho"value="Administrator"/>
      <entry key="Power User"value="powerUser"/>
      <entry key="Report Author"value="reportAuthor" />
      <entry key="Business Analyst"value="businessAnalyst"/>
    </util:map>
    
    
    <util:listid="powerUser">
      <value>org.pentaho.scheduler.manage</value>
      <value>org.pentaho.repository.read</value>
      <value>org.pentaho.repository.create</value>
      <value>org.pentaho.security.publish</value>
    </util:list>
           
    <util:listid="reportAuthor">
      <value>org.pentaho.repository.read</value>
     <value>org.pentaho.repository.create</value>
     <value>org.pentaho.security.publish</value>
    </util:list>
     
    <util:listid="businessAnalyst">
      <value>org.pentaho.repository.read</value>
     <value>org.pentaho.repository.create</value>
    </util:list>
     
    <util:mapid="role-mappings">
      <entry key="Power User"value-ref="powerUser" />
      <entry key="Report Author"value-ref="reportAuthor" />
      <entry key="Business Analyst"value-ref="businessAnalyst"/>
    </util:map>
    now you have mapped all your roles. you can restart your BIserver

  3. #3
    Join Date
    May 2014
    Posts
    2

    Default

    I have same problem , I use jboss eap 6.3 eap with bi server 5.0..1. CE and one db Oracle , when add news role's maybe role mapping isn't ok :S

    Any comments ?

    Thanks !

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.