Role definitions - predefined roles

Applies to: ✅ SQL Server 2016 (13.x) Reporting Services and later ✅ Power BI Report Server

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.

How to use predefined roles

  1. Review the predefined roles to determine whether you can use them as is. If you need to adjust the tasks or define other roles, you should do adjust them before you begin assigning users to specific roles. To create or edit custom roles, use SQL Server Management Studio. For more information, see Create, delete, or modify a role (Management Studio).

  2. Identify which users and groups require access to the report server, and at what level. Most users should be assigned to the Browser role or the Report Builder role. A smaller number of users should be assigned to the Publisher role. Few users should be assigned to Content Manager.

  3. When you're ready to assign user and group accounts to specific roles, use the web portal. For more information, see Grant user access to a report server.

Predefined role definitions

Predefined roles define the tasks they support. You can modify these roles or replace them with custom roles.

Scope defines the boundaries within which roles are used. Item-level roles provide varying levels of access to report server items and operations that affect those items. Item-level roles are defined on the root node (Home) and all items throughout the report server folder hierarchy. System-level roles authorize access at the site level. Item and system-level roles are mutually exclusive but are used together to provide comprehensive permissions to report server content and operations.

The following table describes the predefined scope of the roles:

Predefined role Scope Description
Content Manager Role Item Able to manage content in the Report Server. This access includes folders, reports, and resources.
Publisher Role Item Able to publish reports and linked reports to the Report Server.
Browser Role Item Able to view folders, reports, and subscribe to reports.
Report Builder Role Item Able to view report definitions.
My Reports Role Item Able to publish reports and linked reports; manage folders, reports, and resources in a users 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

The Content Manager role is a predefined role that includes tasks that are useful for a user who manages reports and Web content, but doesn't necessarily author reports or manage a Web server or SQL Server instance. A content manager deploys reports, manages report models and data source connections, and makes decisions about how reports are used. All item-level tasks are selected by default for the Content Manager role definition.

The Content Manager role is often used with the System Administrator role. Together, the two role definitions provide a complete set of tasks for users who require full access to all items on a report server. Although the Content Manager role provides full access to reports, report models, folders, and other items within the folder hierarchy, it doesn't provide access to site-level items or operations. Tasks such as creating and managing shared schedules, setting server properties, and managing role definitions are system-level tasks that are included in the System Administrator role. For this reason, we recommend that you create a second role assignment at the site level that provides access to shared schedules.

Content manager tasks

The following table lists the tasks that are included in the 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 nonlinked 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. It also supports the editing and execution of scheduled refresh for Power BI (.pbix) files in Power BI Report Server.
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. This task also supports the editing and execution of scheduled refresh for Power BI (.pbix) files in Power BI Report Server.
Manage models Create, view, and delete models, and view and modify model properties.
Manage report history Create, view, and delete report history, and view report history properties. Also includes 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. Also includes 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. For more information, see Securable Items.
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.

Customizing the content manager role

This role is intended for trusted users who have overall responsibility for managing and maintaining report server content. You can remove tasks from this definition, but doing so might introduce ambiguity into what can be managed. For example, removing the "View reports" task from this role definition would prevent a Content Manager from viewing report contents and therefore be unable to verify changes to parameter and credential settings.

The Content Manager role is used in default security.

Publisher role

The Publisher role is a built-in role definition that includes tasks that enable users to add content to a report server. This role is predefined for your convenience. It isn't used until you create role assignments that include it. This role is intended for users who author reports or models in Report Designer or Model Designer and then publish those items to a report server.

Caution

Permission to publish items to a report server should be granted only to trusted users. The Publisher role grants wide-ranging permissions that allow users to upload any type of file to a report server. If an uploaded report or HTML file contains malicious script, any user who selects the report or HTML document will run the script under his or her credentials.

Report definitions can include script and other elements that are vulnerable to HTML injection attacks when the report is rendered in HTML at run time. If a published report contains malicious script, any user who runs that report might accidentally cause the script to run when the report is opened. If the user has elevated permissions, the script runs with those permissions.

To reduce the risk of users accidentally running malicious scripts, limit the number of users who have permission to publish content. Also, make sure that users only publish documents and reports that come from trusted sources. If you aren't sure whether a report definition is safe to publish, you should open the .rdl file in a text editor and search for script tags. Malicious script can be hidden in expressions and URLs (for example, a URL in a navigation action).

Publisher tasks

The following table lists the tasks that are included in the 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, and view and modify report properties. Also includes 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.

Customizing the publisher role

You can modify the Publisher role to suit your needs. For example, you can remove the "Create linked reports" task if you don't want users to be able to create and publish linked reports. Or, you can add the "View folders" task so that users can navigate through the folder hierarchy when selecting a location for a new item.

At a minimum, users who publish reports from Report Designer need the "Manage reports" task to be able to add a report to the report server. Include "Manage data sources" and "Manage resources if the user must publish reports that use shared data sources or external files. If the user also requires the ability to create a folder as part of the publishing process, you must also include "Manage folders."

Browser role

The Browser role is a predefined role that includes tasks that are useful for a user who views reports but doesn't necessarily author or manage them. This role provides basic capabilities for conventional use of a report server. Without these tasks, it might be difficult for users to use a report server.

The Browser role should be used with the System User role. Together, the two role definitions provide a complete set of tasks for users who interact with items on a report server. Although the Browser role provides view access to reports, report models, folders, and other items within the folder hierarchy, it doesn't provide access to site-level items such as shared schedules, which are useful to have when creating subscriptions. For this reason, we recommend that you create a second role assignment at the site level that provides access to shared schedules.

Browser tasks

The following table describes the tasks that are included in the 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.

Customizing the browser role

You can modify the Browser role to suit your needs. For example, you can remove the "Manage individual subscriptions" task if you don't want to support subscriptions. Or, you can remove the "View resources" task if you don't want users to see collateral documentation or other items that might be uploaded to the report server.

At a minimum, this role should support both the "View reports" task and the "View folders" tasks to support viewing and folder navigation. You shouldn't remove the "View folders" task unless you want to eliminate folder navigation. Likewise, you shouldn't remove the "View reports task" unless you want to prevent users from seeing reports. These kinds of modifications suggest the need for a custom role definition that is applied selectively for a specific group of users.

Report Builder role

The Report Builder role is a predefined role that includes tasks for loading reports in Report Builder and viewing and navigating the folder hierarchy. You must also have a system role assignment that includes the "Execute report definitions" task to create and modify reports in Report Builder. This task is required for processing reports locally in Report Builder.

Report Builder tasks

The following table describes the tasks that are included in the 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.

Customizing the Report Builder role

You can modify the Report Builder role to suit your needs. The recommendations are generally the same as for the Browser role:

  • Remove the "Manage individual subscriptions" task if you don't want to support subscriptions.
  • Remove the "View resources" task if you don't want users to see resources.
  • Keep "View reports" task and the "View folders" tasks to support viewing and folder navigation.

The most important task in this role definition is "Consume reports," which allows a user to load a report definition from the report server into a local Report Builder instance. If you don't want to support this task, you can delete this role definition and use the Browser role to support general access to a report server.

My Reports role

The My Reports role is a predefined role that includes a set of tasks that are useful for users of the My Reports feature. This role definition includes tasks that grant administrative permissions to users over the My Reports folder that they own.

Although you can choose another role to use with the My Reports feature, you should choose one that is used exclusively for My Reports security. For more information, see Secure My Reports.

My Reports tasks

The following table lists tasks that are included in the 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. Also includes 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. Also includes 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.

Customizing the My Reports role

You can modify this role to suit your needs. However, you should keep the "Manage reports" task and the "Manage folders" task to enable basic content management. In addition, this role should support all view-based tasks so that users can see folder contents and run the reports that they manage.

Although the "Set security for individual items" task isn't part of the role definition by default, you can add this task to the My Reports role so that users can customize security settings for subfolders and reports.

System administrator role

The System Administrator role is a predefined role that includes tasks that are useful for a report server administrator who has overall responsibility for a report server, but not necessarily for the content within it.

To create a role assignment that includes this role, use the Site Settings page in the web portal, or use the right-click commands on the report server node in Management Studio.

The System Administrator role doesn't convey the same full range of permissions that a local administrator might have on a computer. Rather, the System Administrator role includes operations that are performed at the site level, and not the item level. For users who require access to both site-wide operations and items stored on the report server, create a second role assignment on the Home folder that includes the Content Manager role. Together, the two role definitions provide a complete set of tasks for users who require full access to all items on a report server.

System administrator tasks

The following table lists tasks that are included in the 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. For more information, see Manage a running process.
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.

The System Administrator role is used in default security.

System User role

The System User role is a predefined role that includes tasks that allow users to view basic information about the report server. It also includes support for loading a report in Report Builder. Report Builder is a client application that can process a report independently of a report server. The "Execute report definitions" task is intended for use with Report Builder. If you aren't using Reporting Builder, you can remove this task from the System User role.

The following table lists tasks that are included in the System User role definition:

System User tasks

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 isn't available. Also, the application title isn't 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 can't select shared schedules to use with subscriptions and other scheduled operations.

The System User role can be used to supplement default security. You can include the role in new role assignments that extend report server access to report users. For more information, see Granting Permissions on a Native Mode Report Server.

Create, delete, or modify a role (Management Studio)
Grant user access to a report server
Modify or delete a role assignment (SSRS web portal)
Grant permissions on a native mode report server
Tasks and permissions f