CODEWITHSUNDEEP
sql-serverreporting-servicesssas
NebNerlo
NebNerlo

Reputation: 93

Row Level Security on Shared data set SSRS

I'm looking for a way to filter the data to employees something like create a "user to Client relationship", the problem is this is after the fact,I have 100+reports that already exist and I don't want to edit each one, I use a shard Data source, can i somehow implement RLS on that source ? or maybe use ssas RLS in conjunction.

SQL server 2012 enterprise,

Thank you

Upvotes: 1

Views: 1458

Answers (1)

user170442
user170442

Reputation:

One solution which comes to my mind is to add to each shared dataset a part which will filter rows based on domain user name.

This will require that:

  1. User running SSRS report will have to have access to SQL Server
  2. You would have to build tables to define access right (if you do not have already)

If you would be running SQL Server 2014 and onwards you could use built in RLS. You would have to define access right and create access control function. Still you have to have some kind of data store which will help you to determine what is visible to each user - more details on RLS here.

Upvotes: 2

Related Questions