Forum Discussion

tracytran91's avatar
tracytran91
Helper III
4 years ago
Solved

Row Level Security with multi roles

Hi friend, 

 

Could anyone please kindly help me to set RLS for this user?

He is in charge of Thailand region which allows him able to see all products sold in ThaiLand. Meantime, He has additional role in charge of Product Candy which allows him to see performance of candy at all region. 

 

Any help is high appreciated. 

Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi tracytran91 

    try this 

     

    result

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi tracytran91 

    try this 

     

    result

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

    • tracytran91's avatar
      tracytran91
      Helper III
      4 years ago

      v-xiaotang Thank for your solution. 

       

      I would like to ask whether there is a dynamic way to make it work? 

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    tracytran91 , You can not use all. This what I have done. I create a table like this

     

    Product Product All
    A A
    B B
    C C
    D D
    A All
    B All
    C All
    D All

     

    I joined it product column and merged in power query(on product All)  and removed all and got the products

    The same need to be done for the region