Forum Discussion

ashishg's avatar
ashishg
Advocate I
2 years ago
Solved

how to setup RLS for multiple AD group based on country

I have two tables , Table1 and Table2, Table1 is connected to all other table and my Table2 is user ad group table. and relationship between Table1 to Table2 is one-to-many. so one country person can...
Need Help
  • audreygerred's avatar
    audreygerred
    2 years ago

    Hi! You have to have each individual's email address listed in your model with what country they are associated with. To assign the access in service once you publish the model you can use the AD group, but the model itself has to have everyone's individual email ID since that is what they login with.

ashishg's avatar
ashishg
Advocate I
2 years ago

Hi audreygerred 
Thank you for the resposnse

Is there any way I can create a table for where I nominate each AD group to country and when user will log in it will take directly RLS to that specific country only

audreygerred's avatar
audreygerred
Super User
2 years ago

Hi! You have to have each individual's email address listed in your model with what country they are associated with. To assign the access in service once you publish the model you can use the AD group, but the model itself has to have everyone's individual email ID since that is what they login with.