How To configurate permissions to a DataSource.

[Moterosk]

Hi all,


I have created an interactive Dashboard in Pentaho 7, and it works fine.




With the Schema Workbench I have configurated permissions and roles acces via MDX queries,(for example if determinate user is allowed to view only data from a country , only show those data from that country).


I want to do something similar with sql queries within the same dashboard.


I have completed all the steps from this tutorial: https://support.pentaho.com/hc/en-us...curity-to-JDBC


I have table full of data at MySql DDBB --> USERS,AUTHORITIES and GRANTED_AUTHORITIES.


But I dont know how to implementate it in the CDA files to have an role-based access control pentaho depending of the result in a sql query (Similar to MDX system role based).


Really thanks in advance.

[jammartinez760]

hi I have almost the same problem please let me know if you find out how to solve this problem