x

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

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(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

ignaciooliver gravatar image

ignaciooliver
120 2 2 3

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1951
x558
x163

asked: May 14, 2012 at 03:09 PM

Seen: 1261 times

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