Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Reporting Services
 Securing Folders
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
Securing Folders

Folder security is the foundation for securing all content in a report server. Because security is inherited throughout the folder structure, you can designate large or small sections of the folder hierarchy to allow for certain kinds of access.

High-security folders can be used to store confidential reports or as staging areas; for example, you can have a folder that you use to test reports before moving them to a final location. To control access to this area, you can define one role assignment that allows only report authors to add and delete items, and a second role assignment that allows testers to run reports but not to add or remove items. Because the role assignments are defined explicitly for testers and report authors, no other users (except for local system administrators) can access the folder.

Low-security folders can be used to store reports that you want to be easily accessible.

Folder security forms the basis of item-level security, starting with the root node of the report server folder hierarchy, the Home folder. Because security is inherited, it is advisable to set a fairly restrictive security policy on the Home folder. Using the Browser role in Home folder role assignments does exactly that by providing view-only access.

When creating role assignments for folders, consider the tasks listed in the following table.

Select this task To give permission to

View folders

View the folder hierarchy and read-only properties that indicate when the folder was created and modified.

Users cannot view items in the folder unless they are assigned to roles that also include the following tasks: "View reports," "View models", "View resources," and "View data sources."

Manage folders

View folder properties, change the name or description, or move the folder to another location. This task allows users to create folders.

Manage reports

Add reports from the file system to a folder and publish reports from Report Designer to the report server.

Manage data sources

Add new shared data source items to a folder and change existing shared data sources.

Set security on items

Create and modify role assignments that control access to the folder. This task must be used with either "View folders" or "Manage folders." If it is not, it will have no effect because the user will not be able to select the item.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker