Reporting Services - security settings

Hi, we have security settings on the Home folder of our SSRS server with specified accounts having specified security settings.
Everyone is not in there.
I now need to add a new folder in the Home folder and give a new group access to that, and only that, folder.
The new group is not a member of any of the groups that currently have permission to the Home folder.
All folders have inherit security from the above folder.

How do I get the new group to have permissions to their folder and not to the other folders? Do I have to give them permission to the Home folder and then turn off inheritance on all sub-folders? This seems a big job (there are 30+ sub-folders) and I'm wondering if there is a code-based solution or other shortcut?

more ▼

asked May 14, 2012 at 03:09 PM in Default

avatar image

Fatherjack ♦♦
43.8k 79 102 118

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

What I usually do in this case is turn off inheritance for the new folder and give the group access just to that folder.

Because of this they won't be able to see the home folder so I send them the link to the actual folder instead of the Home.

more ▼

answered May 14, 2012 at 03:38 PM

avatar image

120 2 2 4

OK, this might work in our scenario. It's a bit of a work around rather than a solution though.

May 14, 2012 at 05:17 PM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 14, 2012 at 03:09 PM

Seen: 1478 times

Last Updated: May 14, 2012 at 05:17 PM

Copyright 2018 Redgate Software. Privacy Policy