User Roles and Permissions in SSRS

User Roles and Permissions in SSRS

In this article, I will show you how to create User Roles and assign roles & permissions to users in SSRS.

Before starting this please go through below details about roles.

The Browser Role : The Browser role is the basic role assigned to users who are going to view reports. The Browser role has rights to perform the following tasks:

  • Manage individual subscriptions
  • View folders
  • View models
  • View reports
  • View resources

The Publisher Role The Publisher role is assigned to users who are going to create folders and upload reports. The Publisher role has rights to perform the following tasks:

  • Create linked reports
  • Manage data sources
  • Manage folders
  • Manage models
  • Manage reports
  • Manage resources

The My Reports Role The My Reports role is designed to be used only with a special folder called the My Reports folder. Within this folder, the My Reports role gives the user rights to do everything except change security settings. The My Reports role has rights to perform the following tasks:

  • Create linked reports
  • Manage data sources
  • Manage folders
  • Manage individual subscriptions
  • Manage report history
  • Manage reports
  • Manage resources
  • View data sources
  • View folders
  • View reports
  • View resources

The Content Manager Role The Content Manager role is assigned to users who are managing the folders, reports, and resources. All members of the Windows local administrators group on the computer hosting the report server are automatically members of the Content Manager role for all folders, reports, and resources. The Content Manager has rights to perform all tasks, excluding system-wide tasks. 

The System User Role The system-wide security tasks have two predefined roles.The System User role has rights to perform the following system-wide tasks:

  • Execute report definitions
  • View report server properties
  • View shared schedules

The System Administrator Role The System Administrator role provides the user with rights to complete any of the tasks necessary to manage the report server. All members of the Windows local administrators group on the computer hosting the report server are automatically members of the System Administrator role. This role has rights to perform the following system-wide tasks:

  • Execute report definitions
  • Manage jobs
  • Manage report server properties
  • Manage report server security
  • Manage roles
  • Manage shared schedules

1. First of all open Internet Explorer and go to Report Manager URL which is something like below:

http://bhushan-pc/Reports2012

Your browser tab looks like below :

1-User Roles and Permissions in SSRS

2. Now click on the link of Site Settings which is on the right top corner. Then click on the Security from the left pane. You will see results like below.

2-User Roles and Permissions in SSRS

Here you will see BUILTIN\Administrators user assigned to System Administrator role.

3.To add New Role Assignment, click on the link of New Role Assignment as Shown in below screenshot.

3-User Roles and Permissions in SSRS

4. In next screen, Enter the Group or User Name and select role based on your requirement. Please see below screenshot.

4-User Roles and Permissions in SSRS

Then click on OK button. Here you can see the list of Roles which are assigned to group or users.

4-User Roles and Permissions in SSRS-1

5. Now click on the link of Home and then click on the link of Folder Settings.

5-User Roles and Permissions in SSRS

6. You will see results like following.

6-User Roles and Permissions in SSRS

7. Then click on New Role Assignment and you will see like below screenshot.

7-User Roles and Permissions in SSRS

In that screen Enter group or user name and select roles as par your requirement.Here we will add Administrator and assign roles of Content Manager & My Reports. Then click on OK button.

7-User Roles and Permissions in SSRS-1

Here you can see added role.

7-User Roles and Permissions in SSRS-2

Congratulations! We successfully created User Roles and Permissions in SSRS.

One thought on “User Roles and Permissions in SSRS

Leave a Reply

Your email address will not be published. Required fields are marked *