Forum Discussion
Row level security exempt
Anonymous ibarrau
So once RLS mode in place, a role has to be created to each user/department.
In my case I had definded roles to only Sales users (users[user_name]= "Sales Name")
As a workaround, I just created a conditional column (users[SeniorManagement] which has a value of "SM" to all sales users, and then created a role SM (users[SeniorManagement]= "SM") and then I added all SM users so they can see all the data
Thanks for your respond guys.
Cheers,
Majd
majdkaid22I think you may have misunderstood me. You can create a single role for all of your sales managers or whatever. You do not have to create a separate role for each individual manager. You just have to assign each user to actually use that role once you publish. After publishing, go to Datasets, right click on the dataset with the row level security and click on "Security" in the menu that pops up. You will see the roles you have created. Add user accounts to that role and save.
Anonymous appreciated buddy. that exactly what I did. Now I have all sales users under one role where they can only see their associated data, and Senior Management under a different role where they can see all the data.
Cheers,
Majd