Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

RLS off for Certain Pages

Hey,

 

I am wanting to have the ability to have RLS off for the home page (so users can see all data), however for the remaning pages I want RLS to be active so the underlying and detailed data is secure. 

 

I currenlty have RLS working across the report however the front page is also being filtered.

 

Thanks,

 

Chris

Data Protection
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    RLS is set on the dataset. If you want the home page not to be restricted by RLS, you need to use data tables without RLS on the home page. That is to say, the data of the home page is independent of the data model of other pages.

    For example:

     

    Best regards,
    Lionel Chen

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , I think for you might have create a  summary or unsecured table and us that.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      How would I go about doing that? Could you please show me an example 🙂 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    RLS is set on the dataset. If you want the home page not to be restricted by RLS, you need to use data tables without RLS on the home page. That is to say, the data of the home page is independent of the data model of other pages.

    For example:

     

    Best regards,
    Lionel Chen

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