Forum Discussion
Help with setting up RLS - making group for Sales rep and all Access
Hi there,
In my data model I have a employees table that has their email, full name, firstN and last name. I have the joined onto a fact table that only contains their full name. I created a RLs group for our sales reps and it works perfect. When i am signed in as the user it only shows their data. Now I still want to be able to let certain users be able to have full access to the whole entire data and see all the sales reps data. How would I go about giving someone full access in the same data model? I can see all the data fine, but i am the admin of the work space. Others users can not. I would prefer not having to create a copy of my data model and reports just to have rls enabled and let others have full view access.
alex20p Could you just create a new role with an RLS rule of like 1=1 so that it is always true?
2 Replies
- GeraldGEmerickSuper User
alex20p Could you just create a new role with an RLS rule of like 1=1 so that it is always true?
- alex20pAdvocate I
GeraldGEmerick that worked thank you!!