Forum Discussion
RLS with multiple columns
This may be a stupid question, we did try that method but the user can't choose their role correct?
So when both roles are selected you will get the results I was getting before. We added buttons to try and seperate the two roles but still not effective at seperating the roles (parameters didn't quite work either).
Of course it will. What do you expect as a result when you select two roles.
When "John Doe" is evaluated PBI will show the result set.
Why would you use both roles at the same time? You are Seller or Admin role.
Does it make sense to establish RLS in that case?
That`s my undestanding on this topic.
Regards
They get their bonus' on both their Seller and Admin accounts. They need to see both roles but seperate since Admins are calculated differently so if John Doe is the Admin but not the seller he shouldn't see that sellers totals in his seller total. They do hold both roles.
We don't want Sellers or Admins to be able to filter to anyone but themselves, is there another way to restrict data similar to this without RLS?