Tutorial: Setting Permissions in Reporting Services
New: 17 July 2006
Reporting Services uses roles and role assignments to control access to report server content. By creating role assignments, you enable other users in your organization to view and publish reports and other items on a report server.
There are two categories of roles: system-level and item-level. System-level role assignments specify a collection of tasks that apply to the report server site as a whole. Item-level role assignments describe tasks that apply to content, including permissions for publishing reports, generating models, viewing reports, setting properties, creating subscriptions, and so on. System-level and item-level role assignments are used together to provide a comprehensive set of permissions; even users who require limited access to a report server will benefit from having a system-level role assignment.
What You Will Learn
This tutorial will teach you how to use Management Studio to define role assignments that grant access to report server content.
This tutorial assumes that you are a local administrator, configuring report server access on a new installation for the users in your organization. Reporting Services uses Windows authentication by default. If you are using forms authentication instead of Windows authentication, specify group or user accounts that are valid for the custom authentication extension that is deployed on your report server.
This tutorial is divided into three lessons:
- Lesson 1: Setting System-level Permissions on a Report Server
In this lesson you will learn how to use Management Studio to configure site-wide permissions.
- Lesson 2: Setting Item-level Permissions on a Report Server
In this lesson you will learn how to set permissions for accessing report server content, including reports, models, folders, shared data sources, and resources.
- Lesson 3: Setting Permissions on Specific Items
In this lesson you will learn how to override inherited security settings by creating a role assignment on a specific report within the report server folder hierarchy.
Note
This tutorial uses Management Studio to create role assignments. You can also use Report Manager to accomplish the same task. For more information, see How to: Create, Delete, or Modify a System Role Assignment (Report Manager).
Requirements
This tutorial requires that you know how to use SQL Server Management Studio and Report Manager. For more information about how to find these tools, see Tutorial: Reporting Services Tools.
The report server must be running in native mode.
You must have administrator permissions on the local computer.
You must have installed the AdventureWorks sample reports and sample database, and published the sample reports to a report server. For more information, see Installing Samples and AdventureWorks Report Samples.
Estimated time to complete the tutorial: 30 minutes.
Note
When reviewing tutorials we recommend that you add the Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.
See Also
Concepts
SQL Server Management Studio Tutorial
Other Resources
Deployment Modes for Reporting Services
Report Manager
Installing Samples
Managing Permissions and Security for Reporting Services
Predefined Role Assignments