Forum Discussion
Row Level Security question
hi Anonymous - the security in the role you are creating should be
[Salesperson Team] = "Authorized Resller" || [ [Salesperson Team] = "Business Development" - as in the user should have access to Authorized Reseller OR Business development; you had previously set it up as an AND condition.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Here is my RLS scenario:
I have a few managers that need to see salespeople in the two groups below. The "authorized reseller" team by itself works perfectly fine in the RLS environment. My hope was that I could just add the additional team (business development) by just adding && and the other team name. So something like: [Salesperson Team] = "Authorized Resller" && [ [Salesperson Team] = "Business Development". This does not work and ends up making everything disappear.
Is there a way to do this?
hi Anonymous - the security in the role you are creating should be
[Salesperson Team] = "Authorized Resller" || [ [Salesperson Team] = "Business Development" - as in the user should have access to Authorized Reseller OR Business development; you had previously set it up as an AND condition.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Thanks Everyone Anonymous and v-janeyg-msft
Sumanth's solution was the easiest and ultimately what I needed but thanks to Jane as well...I might be able to use that idea in the near future.