How to provide access to SSRS Reports – Giving access only on specific activity

SSRS Access will be managed through Roles only. Giving access to a user or group is assigning the user/group to a specific role. This can be done through the SSRS Reports. Each roles will be assigned with specific tasks so user gets access to the tasks.

SSRS Report access can be managed at Site level or at Specific Folder level.

Site Level Access:
• Open the SSRS Report
• Site Settings -> Security
• New Role Assignment or Edit if the user is already has some access
• Select the roles to be mapped to
o There will be 2 Roles available at Site Level
 System Administrator
 System User
• Click on Apply

Giving access to a specific Folder;
• Open the SSRS Report
• Go to Home Page (Home)
• Scroll the mouse over to the folder which needs access, Click on Down Arrow
o SSRS_20170529
• Select Security
• New Role Assignment or Edit if the user is already has some access
• Select the roles to be mapped to
o There will be 5 Roles available at Folder Level
 Browser
 Content Manager
 My Reports
 Publisher
 Report Builder
• Click on Apply

User Defined Roles:
There could be a scenario where user/group needs access on specific tasks or group of specific tasks which are not pre-defined. This can be achieved by connecting to the Reporting Server using SSMS and creating new Roles (Both System Roles and Folder Level Roles can be created with specific tasks)
Ref: https://docs.microsoft.com/en-us/sql/reporting-services/security/role-definitions-create-delete-or-modify

Task: Task is the Specific operation that can be performed on SSRS

• Tasks and Permissions: https://technet.microsoft.com/en-us/library/ms159840(v=sql.105).aspx
• System Level Tasks: https://technet.microsoft.com/en-us/library/ms157353(v=sql.105).aspx
• Item Level Tasks: https://technet.microsoft.com/en-us/library/ms160344(v=sql.105).aspx

• PreDefined Roles: https://technet.microsoft.com/en-us/library/ms159840(v=sql.105).aspx

• More about granting access on a Native Mode Report Server: https://docs.microsoft.com/en-us/sql/reporting-services/security/granting-permissions-on-a-native-mode-report-server

Advertisements
This entry was posted in Productivity, Uncategorized and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s