Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 PERMISSION on rrss

Author  Topic 

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2011-12-05 : 15:04:09
I want to grant permission to an user to view all the reports. We have 10 folders with different numbers of reports in them. However after granted him permission he is able to see only 2 instead of 10 folders.
The way I did it is I went On SSRS server http://192.168.2.123/Reports -> FOLDER SETTINGS -> SECURITY -> NEW ROLE ASSIGNMENT and checked on all the ROLES

igorkruk.pl
Starting Member

4 Posts

Posted - 2011-12-06 : 09:50:09
I guess other 8 folders have specific permissions set which are not inherited from parent (root) folder.
Can you check it?

---------------------
my website: www.igorkruk.pl
Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2011-12-06 : 12:45:31
I fixed it. I had to go to every folder and add the new user.
Go to Top of Page
   

- Advertisement -