Hi I have an issue in security management. We have many folder under home. Say A, B, C... Now i want to give brower permission to Home-> C folder-> reports to a user user1. But when i try to do it, user1 can able to view all the folders (A,B and C) Pls help how to restrict the access in viewing other folders for the user1.- Kerobin

What are the permissions on the other folders, and can user1 see the contents of A and B also? This may be a case where a different approach may work better. Maybe use completely separate doc libraries instead of folders in one library?Laura Rogers, MCSE, MCTS SharePoint911: SharePoint Consulting Blog: http://www.sharepoint911.com/blogs/laura Twitter: WonderLaura

Did you check the security for the root folder. Maybe user1 is explicitly specified to grant access for the root folder or through ACL group?

There is no permission for User1 so far. But i want the user1 should able to access the home page and should able to see only C folder and the reports in them. What happens is when i try to give browser permission to home page and the folders under home page automatically get inherited the browser permission. So the user1 can able to see A, B and C folders. I even tried doin it in reverse. Say permission to the reports first. and then the folder C. and when it comes to Home page, it again gets inherited the browser permission. Any help would be greatly appreciated. :)- Kerobin

Hi Kerobin, Follow these steps to achieve your purpose: 1. Open the Report Manger, go to the Home Properties page 2. Click the "New Role Assignment", add the user user1 and assign Browser role to him, then click OK. 3. Go the C folder Properties page, click Security to open its securtity page, then click "Revert to Parent Security" and press OK in the pop-up dialogue box. The user user1 will be in the User or Group list. 4. Repeat the step 3 for A and B folders, the user user1 also will be in their User or Group List, click "Edit Item Security" button, then select the user and click "X" to delete the user user1. after these steps, the user1 should be able to only see C folder in the Home page. thanks, Jerry

Thanks for your Reply Jerry! This holds good for 3 or 10 folders under report manager. In my production environment i have close to 60 folders like this. And we want to maintain privacy between folders and user groups. In such case it is really a painfull job to delete the user from each folder. I wish there is some workaround to do it painlessly. Thanks again for your help!- Kerobin

Hi Kerobin, To do a mass update of report manager security permissions, you need write custom assemblies, here is example code for your reference at http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/e8fc40c8-974b-48c5-991e-c2c75f2a0c69 . thanks, Jerry

Well, that is interesting. Thanks Jerry!!- Kerobin