How to: Set Permissions for Report Server Items on a SharePoint Site

New: 12 December 2006

If default security settings do not provide the level of access that you require, you can edit permissions to provide access to specific report server items or operations. Custom security settings can be useful if you want to restrict access to a particular report, or if you want to elevate permissions on a model to enable model item security.

You must be a site owner to edit permissions or create permission levels and groups. Permission levels are used globally throughout a site. If you create a new permission level, it will be available to other site owners.

Most permissions are inherited from a parent site. If you assign permissions on a specific library or item, you break permission inheritance and incur additional overhead in how manage permissions for that branch of your site hierarchy.

You can set permissions on report definition (.rdl), model (.smdl), and shared data source (.rsds) files. You cannot combine inherited and managed permissions on the same item. If you choose to manage permissions directly, inherited permissions will have no affect on the current item. If you want to resume permission inheritance later, you can choose Inherit Permissions on the Actions menu.

To set permissions on entities and perspectives in a model, you must have Full Control level of permission for the model. Full Control includes "Manage Permissions", which is a site level permission that is granted to site owners and other SharePoint groups who have Full Control level of permission. If you want to offer specific users the ability to set model item security, you must break permission inheritance and grant elevated permissions (such as Full Control) to the user or group on the model file. When you grant Full Control on an item such as a file in the library, the permissions are scoped to that item and do not extend to the parent or to other items within the same library. After the user has Manage Permissions permission on the model, he or she can use set model item security via the SharePoint site or Model Designer.

To set permissions on an individual report, model, or data source

  1. If the library is not already open, click its name on the Quick Launch bar. If the name of your library does not appear, click View All Site Content, and then click the name of your library.

  2. Point to the report, report model, or shared data source file.

  3. Click the down arrow, and on the menu, click Manage Permissions.

  4. On the Actions menu, click Edit Permissions, and then click OK.

  5. To give permissions to a user or group that does not yet have permissions to use the file, click New, and then click Add Users.

  6. To remove or modify permissions for an existing user or group, click the check box next to the user or group, click Actions, and then click Remove User Permissions or Edit User Permissions.

To set permissions that enable model item security

  1. Log in to the SharePoint site using an account that has Manage Permissions permission on the site.

  2. Open the library that contains the model.

  3. Point to the model.

  4. Click the down arrow next to the model, and click Manage Permissions.

  5. Click Actions.

  6. Click Edit Permissions. Click OK.

  7. Click New.

  8. Click Add Users.

  9. In Users/Groups, enter the user account.

  10. Select Give users permission directly.

  11. Click Full Control.

  12. Click OK. Once a user has the ability to manage permissions for a specific model, he or she can open the model to edit permissions within the model. For more information, see How to: Set Permissions on Model Items (SharePoint Integrated Mode).

See Also

Tasks

How to: Set Permissions on Model Items (SharePoint Integrated Mode)

Concepts

Report Server How-to Topics (SharePoint Integrated Mode)
Using Built-in Security in Windows SharePoint Services for Report Server Items
Setting Permissions for Report Server Operations in a SharePoint Web Application
Comparing Roles and Tasks in Reporting Services to SharePoint Groups and Permissions
Site and List Permission Reference for Report Server Items
Managing Permissions and Security for Report Server Items on a SharePoint Site

Help and Information

Getting SQL Server 2005 Assistance