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?