SSRS Roles

Reporting Services installs with predefined roles that you can use to grant access to report server operations. Each predefined role describes a collection of related tasks. You can assign groups and user accounts to predefined roles to provide immediate access to report server operations.

Predefined roles:

The following table describes the predefined scope of the roles:

Predefined role	Scope	Description
Content Manager Role	Item	May manage content in the Report Server. This includes folders, reports, and resources.
Publisher Role	Item	May publish reports and linked reports to the Report Server.
Browser Role	Item	May view folders, reports, and subscribe to reports.
Report Builder Role	Item	May view report definitions.
My Reports Role	Item	May publish reports and linked reports; manage folders, reports, and resources in a user’s My Reports folder.
System Administrator Role	System	View and modify system role assignments, system role definitions, system properties, and shared schedules, in addition to create role definitions, and manage jobs in Management Studio.
System User Role	System	View system properties, shared schedules, and allow use of Report Builder or other clients that execute report definitions.

 Content manager role:

Task	Description
Comment on reports	Create, view, edit, and delete comments on reports.
Consume reports	Reads report definitions.
Create linked reports	Create linked reports that are based on a non-linked report.
Manage all subscriptions	View, modify, and delete any subscription for reports and linked reports, regardless of who owns the subscription. This task supports the creation of data-driven subscriptions.
Manage comments	Delete other users' comments on reports.
Manage data sources	Create and delete shared data source items, view, and modify data source properties and content.
Manage folders	Create, view, and delete folders, and view and modify folder properties.
Manage individual subscriptions	Create, view, modify, and delete user-owned subscriptions to reports and linked reports.
Manage models	Create, view, and delete models, and view and modify model properties.
Manage report history	Create, view, and delete report history, view report history properties, and view, and modify settings that determine snapshot history limits and how caching works.
Manage reports	Add and delete reports, modify report parameters, view and modify report properties, view and modify data sources that provide content to the report, view and modify report definitions, and set security policies at the report level.
Manage resources	Create, modify, and delete resources, and view and modify resource properties.
Set security for individual items	Define security policies for reports, linked reports, folders, resources, and data sources
View data sources	View shared data source items in the folder hierarchy.
View folders	View folder contents and navigate through the folder hierarchy.
View models	View models in the folder hierarchy, use models as data sources for a report, and run queries against the model to retrieve data.
View reports	Run reports and view report properties.
View resources	View resources and resource properties.

Publisher role:

Task	Description
Create linked reports	Create linked reports and publish them to a report server folder.
Manage comments	Delete other users' comments on reports.
Manage data sources	Create and delete shared data source items, view and modify data source properties and content.
Manage folders	Create, view, and delete folders; view and modify folder properties.
Manage models	Create, view, and delete report models; view and modify report model properties.
Manage reports	Add and delete reports, modify report parameters, view and modify report properties, view and modify data sources that provide content to the report, view, and modify report definitions.
Manage resources	Create, modify, and delete resources; view and modify resource properties.

Browser role:

Task	Description
Comment on reports	Create, view, edit, and delete comments on reports.
Manage individual subscriptions	Create, view, modify, and delete user-owned subscriptions to reports and linked reports, and create schedules in support of those subscriptions.
View folders	View folder contents and navigate the folder hierarchy.
View models	View models in the folder hierarchy, use models as data sources for a report, and run queries against the model to retrieve data.
View reports	Run a report and view report properties.
View resources	View resources and resource properties.

Report Builder role:

Task	Description
Comment on reports	Create, view, edit, and delete comments on reports.
Consume reports	Reads report definitions.
Manage individual subscriptions	Create, view, modify, and delete user-owned subscriptions to reports and linked reports, and create schedules in support of those subscriptions.
View folders	View folder contents and navigate the folder hierarchy.
View models	View models in the folder hierarchy, use models as data sources for a report, and run queries against the model to retrieve data.
View reports	Run a report and view report properties.
View resources	View resources and resource properties.

My Reports role:

Task	Description
Comment on reports	Create, view, edit, and delete comments on reports.
Create linked reports	Create linked reports that are based on reports that are stored in the user's My Reports folder.
Manage comments	Delete other users' comments on reports.
Manage data sources	Create and delete shared data source items, view, and modify data source properties and content.
Manage folders	Create, view, and delete folders, and view and modify folder properties.
Manage individual subscriptions	Create, view, modify, and delete subscriptions for reports and linked reports.
Manage report history	Create, view, and delete report history, view report history properties, and view, and modify settings that determine snapshot history limits and how caching works.
Manage reports	Add and delete reports, modify report parameters, view, and modify report properties, view and modify data sources that provide content to the report, view and modify report definitions, and set security policies at the report level.
Manage resources	Create, modify, and delete resources, and view. and modify resource properties.
View data sources	View shared data source items in the folder hierarchy.
View folders	View folder contents.
View reports	Run reports that are stored in the user's My Reports folder and view report properties.
View resources	View resources and resource properties.

System administrator role:

Task	Description
Execute report definitions	Start execution for report definition without publishing it to a report server.
Manage jobs	View and cancel jobs that are running.
Manage report server properties	View and modify properties that apply to the report server and to items that the report server manages. This task supports renaming the web portal, enabling My Reports, and setting report history defaults.
Manage report server security	View and modify system-wide role assignments
Manage roles	Create, view, and modify, and delete role definitions. Members of the System Administrator role can use the Site Settings page to manage roles.
Manage shared schedules	Create, view, modify, and delete shared schedules that are used to run or refresh reports.

System user role:

Task	Description
Execute report definitions	Run a report without publishing it to a report server.
View report server properties	View properties that apply to the report server, such as the application name, whether the My Reports setting is enabled, and report history defaults. If you remove this task from the System User role, the Site Settings page is not available. Also, the application title is not displayed at the top of each page. By default, the title for the web portal is "SQL Server Reporting Services."
View shared schedules	View shared schedules that are used to run reports or refresh a report. If you remove this task from the System User role, users cannot select shared schedules to use with subscriptions and other scheduled operations.