Domain Row Based Security Based on User Role (from LDAP)

[andyskinner]

Hi,

I need to implement Row level security in a Jasper Domain using the ROLEs that a user is in.  I have a set of users coming from an LDAP source, who are in a set of roles (ROLE_A, ROLE_B etc).  These are coming through into JRS ok.  Now I now need to implement a domain security file based on the role values.  Effectively what I want it to implement in SQL(ish) syntax is;

WHERE person.jasper_role_name IN ({The list of the roles the user is in in JRS})

So I will only get rows from the person table where the logged in user is in the relevant role.

I have looked through the documentation but can`t find a specific example for row based security using roles (it`s all using attributes).

[brice.montandon]

Not sure it will help you but I found it interesting and it talks about role security :

https://www.youtube.com/watch?v=5z0UmsWD0cI&list=PL5NudtWaQ9l7lRpVT0he0gj3mPJ83xM4r&index=20

 

I'm just a beginer user trying to find security answer on the forum so excuse me if the link doesn't help you

 

Regards and good luck