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 :
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.
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.
4. In next screen, Enter the Group or User Name and select role based on your requirement. Please see below screenshot.
Then click on OK button. Here you can see the list of Roles which are assigned to group or users.
5. Now click on the link of Home and then click on the link of Folder Settings.
6. You will see results like following.
7. Then click on New Role Assignment and you will see like below screenshot.
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.
Here you can see added role.
Congratulations! We successfully created User Roles and Permissions in SSRS.
