Hi,

I want to give the permission to a user to view only one folder among 10 folders on Home page. I don't want that user to view other folder than his/Her Own folder on report server home page.

I went through the below URL but it didn't help.

http://blogs.msdn.com/b/sqlforum/archive/2011/01/03/walkthrough-restrict-the-users-to-see-only-their-folders-via-reporting-services-web-services.aspx

Thanks,

Ashish Tr

Hi Ashu,

It's normally easiest to assign permissions at the folder level.  Since permissions inherit by default, using separate folders would allow you to add more reports later, and permissions would be assigned, just by putting them in the right folder.

 

That being said, assigning permissions for Folders and Reports works the same way.

 

1. Open the Folder or Report.

2. Go to the Properties Tab.

3. Click Security on the Left Menu.

4. Click "New Role Assignment" (If Permissions are still being inherited, you will need to click "Edit Item Security" first.)

5. Enter the User Name and put them in the Browser Role.

 

Note: Both users will also need to have Browse Level permissions on the Root Directory, or they won't be able to see the folders that they have permissions on.  In my environment, pretty much all Domain Users have Browse Access on the root directory, but only Folders and Reports that they can use, show up.

Note : If the user is a Local Administrator on the SSRS server.  By default they will be able to see everything.

Hi Milan,

Thanks for the reply, but using this way I can view all the folders though we can not access the folder.

I need a way out using which only that folder would be visible with which that person is associated too, rest all other folders on Home page should be invisible.

Let me know if you have any idea about this.

Thanks,

Ashish Tripathi

On each folder the user is not to have access to you need to break the inheritance of permissions from the parent folder (i.e., the home folder) and remove them.  This would be done through folder security on each folder and editing the security.  Here are a couple of links to help...

https://www.mssqltips.com/sqlservertip/2793/sql-server-reporting-services-2012-permissions/

https://msdn.microsoft.com/en-us/library/aa337491%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396

• Proposed as answer by Qiuyun YuMicrosoft contingent staff, Moderator Friday, September 11, 2015 8:54 AM

Hi Ashish,

According to your description, when user access the report manager, you want the user only can see and access the specific folder in home page, and other folders are hidden, right?

Based on our test, you can grant a system level role for the user in Site Settings. Then grant the user item level role (Browser) in Folder Settings. Then open Security page for the specific folder, create a new role(Browser) for the specific user. In this way, when user access the report manager, he can only see and access the specific folder.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Thanks for the reply Qiuyun, you are on the right track.

can you please also give me some more light on that. so that I will create it and check if it resolved my issue.

Thanks,

Hi Ashish,

1. Grant a system level role for the user in Site Settings

2. Grant the user item level role (Browser) in Folder Settings

3. Open Security page for the specific folder, create a new role(Browser) for the specific user

Best regards,
Qiuyun Yu

Thanks For the Reply Qiuyun, 

to create a specific role to view a single report which task I have to choose as I cant see any task when I am going to create a role under Security for the report server.

Thanks,

Ashish Tripathi

Ashish,

On the folder you granting the user permissions to, select "New Role Assignment", then select "Browser".  This gives them view only.  You don't need to create a a new role but simply grant access through a role, that being "Browser".

Hi Jjordheim

I want to give access to the user on the home page where I want to show him only the required report and if I will allow user to "browser" access then he will not able to login on home page. he has to nevigate to that particular URL which include the folder itself.

Thanks,