Search code examples
reporting-servicessnowflake-cloud-data-platformssrs-2012

How we can implement RLS in SSRS when using Snowflake as a data source


I am using snowflake as a data source and created many SSRS reports. I want to implement row level security on data, so that if a manager opening a SSRS report he can see data related to employee who is working under him.


Solution

  • You can create the RLS in snowflake and when laoding the SSRS you can filter by the user account matching that RLS table

    something similar to what has been mentioned here