12 Replies Latest reply on May 3, 2018 2:30 AM by Tushar More

    Row security setup


      I have a SQL server with sales from all over the World. I would like to limit each user to only see their market, therefore I have been trying to use Row security (dont know if this is the best way)


      I have the following example:


      I link the two files togather with Market, Country and Products and then use this calculation as a filter selected on True.


      My question is if I can make it work the way I want to. Right now it doesnt work with user B since it cant relate to Country or Product. Is there a way to use all if the field is blank?

      Or is there any other suggested ways of working with security in my case?