I'm using Telerik Report Server to manage reporting system for different clients. I have one Main category and I created one report in it. This report has two different data sources(DS1 and DS2), which are populating exactly the same data, but from two different data connections(DC1 and DC2) created on the Telerik Report Server.
DS1 is using DC1 and DS2 is using DC2. These two data connections are created for two different databses/instances.
I also created two users(U1 and U2) and gave them specific permissions.
For U1:Read reports in Main Category and Read Specific Data Connection: DC1
For U2:Read reports in Main Category and Read Specific Data Connection: DC2
When I run the report with U2, I'm seeing data populated from DS1.
Why I'm seeing data with user that don't have access to this particular data connection? How these permissions work?
Is there a way to handle this situation in Telerik Report Designer or Telerik Report Server, using one report instead of two?
1 Answer, 1 is accepted
I have changed the product/forum of the ticket info to Report Server.
When a User has reading permission for a report, he/she can preview a report independent on the connection string used in the report. Granting a User permission for a report you grant permission for connecting to the data source of the report.
Permissions for Data Connections are related to viewing/managing Data Connections in the Data Connection view of the Report Server manager.
The described scenario looks like multitenancy, which is not supported. You can vote for the Add multitenancy support feature request on our Feedback portal.
Currently the workaround is to utilize user function (in the report definition, i.e. Standalone Designer) that returns DataSource object based on the logged user, and link it with Bindings to the DataSource property of the report/data item. This would allow for using one report instead of two.
Regards,
Todor
Progress Telerik