Forum Discussion
Dynamic Row Level Security data setup and questions
Hi all. I'm building a report with multiple levels of managers (rep, district manager, regional managers, sales director) needing access to only their data. Sales director would see whole group, ...
In order for RLS to work right in the service, you need to first add the users to the report dataset security, then publish the report into an app (making sure the users have permission to the app), AND ensure the users are NOT members of the workspace the report is in. When a user is a member of the worksapce all RLS is bypassed for that user.
shadow9600 Thanks - I did discover that was why my internal test wasn't working. Didn't realize you have to apply permissions in two places.
