User based Access in Reporting Services

Bhabani Prasad

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhabani Prasad12y ago
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)
Guest User12y ago
in web.config you can use something like this:
Bhabani Prasad12y ago
can u tell me more how to pull at url level.
Guest User12y ago
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 Prasad12y ago
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
Guest User12y ago
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.,
```
          
```