Forum Discussion

qmartiny's avatar
qmartiny
Icon for Helper III rankHelper III
4 years ago
Solved

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

 

 

2 Replies

  • 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

    • qmartiny's avatar
      qmartiny
      Icon for Helper III rankHelper III

      That was easy.. I don't know why I did not think of this 

       

      Thank you!!