Show/Hide Toolbars

SSRS Subscription Manager Help File

Navigation: » No topics above this level «

Security Requirements

Scroll Prev Top Next More

Before running SSRS Subscription Manager please ensure you have to correct permissions set.

 

 

 

SSRS Native Permission Requirements

 

clip0259

 

There are four System Role permissions of interest.

 

 

Item

Description

View shared schedule

To view shared schedules This is the minimum requirement.

Manage shared schedule

Required to edit shared schedules. If this is not selected you must have View shared schedule permissions (item above)

Generate events

To rerun a subscription

Manage jobs

To stop running subscriptions or adhoc reports

 

 

 clip0257

 

 

 

 Permissions Required for Managing Subscriptions

 

 Note this is a User Role not a System Role.

 

 

 

 

 Edit the user role the user is a member of.  In the screenshot below the role is My Reports but you can create an additional User Role and permission the user to that role.

 Best Practice is to use a domain group  user > group > Role  (User Role and System Role)

 

 

clip0258

 

 

 

SSRS Integrated Permissions Required

 

 https://docs.microsoft.com/en-us/sql/reporting-services/security/set-permissions-for-report-server-operations-in-a-sharepoint-web-application?view=sql-server-2017#permissionSharedSchedules

 

 

Item

Description

Shared schedules

Link

Subscriptions

Link

 

 

 

 SSRS Role Tasks vs SharePoint Group Permissions

 

 https://docs.microsoft.com/en-us/sql/reporting-services/security/reporting-services-roles-tasks-vs-sharepoint-groups-permissions?view=sql-server-2017