SharePoint Site and List Permission Reference for Report Server Items

 

Applies To: SQL Server 2016

This topic provides a reference of the permissions in SharePoint that can be used to grant access to report server operations for a report server that runs in SharePoint integrated mode. If you are creating custom permission levels, this topic can help you choose which permissions to use.

SharePoint provides thirty-three permissions that you can use to control access to content and operations. Some but not all of those permissions apply to documents and operations that involve a Reporting Services report server. You can use the permission reference tables in this article to find out which permissions support specific reporting tasks.

Each table starts with a list of SharePoint permissions and a description. The table includes three columns that indicate how a permission is used in predefined permission levels. The predefined permission levels include the following:

Permission levelAbbreviation
Full ControlF
ContributeC
VisitorV

Permissions that do not affect a report server are not listed. All personalization permissions are excluded from this reference article. Although you can include report server items in a personalized Web site, the report server does not directly handle personalization requests or operations.

Applies to:

 Reporting Services SharePoint mode | SharePoint 2010 and SharePoint 2013.

Permissions that you set on the library that contains report server items determine how users access those items.

PermissionDescriptionFCVReport Server Operation
Manage ListsCreate and delete lists, add or remove columns in a list, and add or remove public views of a list.XCreate a folder in a SharePoint library during a publish operation from an authoring tool. This permission is also required for managing report history.
Add ItemsAdd items to lists, add documents to document libraries, and add Web discussion comments.XXAdd reports, report models, shared data sources, and resources (external image files) to SharePoint libraries. Create shared data sources. Generate report models from shared data sources. Start Report Builder and create a new report or load a model into Report Builder.
Edit ItemsEdit items in lists, edit documents in document libraries, edit Web discussion comments in documents, and customize Web Part Pages in document libraries.

Create subscriptions and edit subscriptions you created.
XXView past versions of a document, including report history snapshots. Edit item properties for reports and other documents. Set report processing options. Set parameters on a report. Edit data source properties. Create report history snapshots. Open a report model or a model-based report in Report Builder and save your changes to the file. Assign clickthrough reports to entities in a model. Replace a report definition, shared data source, report model, or resource with a newer version (replace file, preserve metadata). Manage dependent items that are referenced in a report or model. Customize the Report Viewer Web Part relative to a specific report.

Create, change and delete subscriptions that use the Reporting Services delivery extensions to deliver reports to target locations. Only the subscription owner and users who have Manage Alerts permission can perform these actions.
Delete ItemsDelete items from a list, documents from a document library, and Web discussion comments in documents.XXDelete reports, report models, shared data sources, and other documents from a library.
View ItemsView items in lists, documents in document libraries, and Web discussion comments.XXXOpen a report, report model, and other document and have it processed on the report server.
Open ItemsView the source of documents with server-side file handlers.XXXView a list of shared data sources. Download a copy of the source file for a report definition or report model. View clickthrough reports that use a report model as a data source.
View VersionsView past versions of a list item or document.XXXView past versions of a document and report snapshots.
Delete VersionsDelete past versions of a list item or document.XXDelete past versions of a document and report snapshots.
System_CAPS_ICON_note.jpg Note


Other list permissions include Override Checkout, Approve Items, and View Application Pages. Those permissions are not evaluated by the report server. The report server does not handle those operations.

Site permissions determine access to report server operations that are not directly related to items stored in a specific library. Examples include creating and managing shared schedules, which can be used by items in multiple libraries, and configuring the Report Viewer Web Part, which can be used throughout a site.

PermissionDescriptionFCVReport Server Operation
Manage PermissionsCreate and change permission levels on the Web site and assign permissions to users and groups.XYou can change permissions for all report server items and operations. You can set model item security.
Manage Web SitePerform all administration tasks for the Web site as well as manage content.XCreate, change, and delete shared schedules.
Add and Customize PagesAdd, change, or delete HTML pages or Web Part pages, and edit the Web site using a Windows SharePoint Services-compatible editor.XAdd or remove a Report Viewer Web Part.
Browse User InformationView information about the users of the Web site.XXXBrowse for reports and other items across different sites, libraries, and folders. Publish reports and other items to a library.
Enumerate PermissionsEnumerate permissions on the Web site, list, folder, document, or list item.XRead permissions for all report server items. View a clickthrough report that uses a report model that contains model item security settings.
Manage AlertsManage alerts for all users of the Web site.XCreate, change, and delete any subscription on a site.
Use Remote InterfacesUse SOAP, Web DAV, or SharePoint Designer interfaces to access the Web site.XXXUsed to call the URL proxy endpoint to the report server.
OpenOpen a Web site, list, or folder to access items inside that container.XXXRead schedules and item properties.

Compare Roles and Tasks in Reporting Services to SharePoint Groups and Permissions
Granting Permissions on Report Server Items on a SharePoint Site

Community Additions

ADD
Show: