Forum Discussion

prasanthd's avatar
prasanthd
New Member
2 years ago

Row Level Security for multiple values in a column

Hi Everyone,


I have a scenario where there are multiple values in SITE column.

If the values in SITE column are single like ACH, LYP etc.. then data is showing up when using RLS.

 

In the below Screenshot for the value in EMAILADDRESS is [email protected], the value in SITE is API,MAS. Here when using RLS, SITE value is not showing in the report.

 

Appreciate your response.

Thanks,

Prasanth.

Need Help

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Hi prasanthd ,

     

    Is the API, MAS one single site or two? If this is a value for more tha one site I recommend that you split this into a row for each of the site so in this case Jona would have two rows one for API and anothe for MAS that should return the values you need.

  • prasanthd's avatar
    prasanthd
    New Member
    2 years ago

    Thanks for the response MFelix , I have already tried doing it and its successfull, but my requirement is to get API, MAS as one single site.

    Thanks.

    • MFelix's avatar
      MFelix
      Super User
      2 years ago

      Hi prasanthd ,

       

      When you mean to get the API, MAS has a single site what do you mean? RLS is just the an access to the information if your user has access to both the sites then the calculations will get properly done, the fact that you split the sites on the RLS configuration will not only give you one of the sites, it will return the result for all the sites the user has acess.