Forum Discussion
RLS for star schema model
Hello lovely people
I need to create a RLS at the [_MAL] table level to restrict the access at a regional level.
I cannot use the standard RLS approach to create a filter in the [_MAL] like [REGION] = "AAA"
And I cannot use the cross filter check approach since I have a star schema with multiple bi directional relationships.
I would like to avoid changing the model. How would you create a RLS for this schema?
Thanks a lot
Quentin
qmartiny , Is not possible to create a table with region and email ID it has access to and join it with _MAL and use
[email]= userprincipalname() in role
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
2 Replies
- amitchandakSuper User
qmartiny , Is not possible to create a table with region and email ID it has access to and join it with _MAL and use
[email]= userprincipalname() in role
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
- qmartinyHelper III
That was easy.. I don't know why I did not think of this
Thank you!!