Forum Discussion
RLS from database
Hello all,
I have report which has RLS defined for "Function". In the Manage Roles i have created 4 roles
[FUNCTION_NAME] = "Engineering"
[FUNCTION_NAME] = "ISC"
[FUNCTION_NAME] = "Procurement"
[FUNCTION_NAME] = "Quality" and have defined AD groups respectively in service and it works fine.
Now how will i define for an AD group who can access all functions?
Is it [FUNCTION_NAME] =TRUE()
Kinldy help amitchandak
You can create a role that has no filters assiged or, if you want you can just add TRUE() to the table that holds the Function_Name field which would look something like this:
4 Replies
- jdbuchanan71Super User
You would create a 5th role with no filters on it then assign users that should see all functions to that role.
- harshagrajPost Partisan
Hi jdbuchanan71 thank you but how would i create that? is it just [FUNCTION_NAME]?
- jdbuchanan71Super User
You can create a role that has no filters assiged or, if you want you can just add TRUE() to the table that holds the Function_Name field which would look something like this: