SSRS Subscribe Action and SharePoint Permissions

By Kit

For SQL Server Reporting Services (SSRS) reports there is the ability to create subscriptions. Subscriptions can be scheduled to run on a certain schedule to send emails, export reports to SharePoint document libraries, or save to windows file shares.

Depending on your requirement, you may need to grant or remove access to the subscribe action and can be managed by creating or editing the default SharePoint roles: Read, Contribute, Full Control, etc.

There are two main ways to create a subscription:

  1. Run the report and click Actions -> Subscribe on the Reporting Services Viewer page (RSViewerPage.aspx).
  2. Find the report in the Document Library and then clicking Manage Subscriptions in the edit menu.

To remove the ability for a user to create subscriptions:

  1. Site Actions
  2. Site Settings
  3. Advanced Permissions
  4. Settings -> Permission Levels
  5. Click on the role, for example “Read”
  6. Uncheck the Create Alerts  –  Create e-mail alerts. permission
Before After
SSRS Subscribe Before SSRS Subscribe After
SSR Subscribe SSRS Subscribe

Note: This will also remove their ability to create SharePoint alerts as well (Actions -> Alert me in a list or library).