Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

RLS with different data access for different users

Hi, I need to implement RLS on my report.   The report contains data about different cities. Some users will be given access to one or more cities. Some will be given access to a state and can view...
Show and Tell
Tutorial Requests
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Create a mapping table with a cities, states, countries and users (email address) that have access to that particular subset.  Alternatively, have three mapping tables.

 

Then wire these mapping tables into the geography table of your data model.