User based Access in Reporting Services

Question

Suppose I have 4 Report and i want to give role based access to that report

EX-Report-1 and report-2 can be visible by only Table-1 member and Report -3 and Report-4 can be visible by Table -2 member

Littile bit specific to the topic

-----------------------------------------

Table 1 member ---Bhabani and Prasad means bhabani and prasad can be only see the report 1 and report2 from report server but table 2 member

Table-2 member -- sanjeeb and Lena means sanjeeb and lenka two member only can see the Report3 and report -4

And report are called from front end means from aspx page using microsoft report viewer

Sumit Jolly · Answer

in web.config you can use something like this:

Bhabani Prasad · Answer

Thanks Sumit I appreciate ur answer i thing am very much near to my task. can u help me a single thing like.our production databse is on 2005 but client told me to use sql2012 report server then how i will map 2012 report server to databse(2012)

Bhabani Prasad · Answer

can u tell me more how to pull at url level.

Sumit Jolly · Answer

ok got it. for my reporting needs i use HTML5/Javascirpt libraries and never used ms report viewer. tell me how are you opening reports is it by any URL e.g. http://abc.com/reports/products if yes then we can put rules at URL level via http handler/modules to restrict it.

Bhabani Prasad · Answer

first of all thanks for ur contribution but u didnt get my question i think. i want role base Autorization in Reporting service not in aspx page. so can u help in that regard

Sumit Jolly · Answer

Hi In web.config you can set authorization rules http://weblogs.asp.net/gurusarkar/setting-authorization-rules-for-a-particular-page-or-folder-in-web-config wherein you can allow users or disallow them for certain things e.g.