Create, Delete, or Modify a Role (Management Studio)

Reporting Services provides predefined roles that define a level of access to a report server. Each user or group who requires access to report server does so through a role that describes the tasks that can be performed. Roles are defined for the report server as a whole. You cannot vary a role definition for specific parts of the report server, or specify that a role be used differently depending on the circumstances.

To create, modify, or delete roles, use SQL Server Management Studio. You can only delete roles that are not used.

To assign users and groups to the roles that you create, use Report Manager. For more information, see Grant User Access to a Report Server (Report Manager).

Note

If the report server is configured for SharePoint integrated mode, and you connected to the SharePoint site that the report server is integrated with, you can view and modify the permission levels that control access to report server content and operations.

To create a role definition

  1. In Object Explorer, expand a report server node.

  2. Expand the Security folder.

  3. If you are creating an item-level role definition, right-click Roles, and point to New Role.

    Or, if you are creating a system-level role definition, right-click System Roles, and point to New System Role.

  4. Type a unique name for the role. A name must contain at least one character. It can also include spaces and certain symbols, but not the characters ; ? : @ & = + , $ / * < > | " or /.

  5. Optionally type a description. In Management Studio this description is visible only on this page. Users who view this item through Report Manager can see this description in that tool.

  6. Select the tasks that members of this role can perform.

  7. Click OK.

To delete or modify a role definition

  1. In Object Explorer, expand a report server node.

  2. Expand the Security folder.

  3. To delete or modify an item-level role definition, expand the Roles folder. Perform one of the following:

    1. To delete a role definition, right-click the item and click Delete. The Delete Object dialog box is displayed. Click OK.

    2. To modify a role definition, right-click the item and click Properties. The General page of the User Role Properties dialog box is displayed.

      Select the tasks that members of this role can perform, and click OK.

  4. To delete or modify a system-level role definition, expand the System Roles folder. Perform one of the following:

    1. To delete a system role definition, right-click the item and click Delete. The Delete Object dialog box is displayed. Click OK.

    2. To modify a system role definition, right-click the item and click Properties. The General page of the System Role Properties dialog box is displayed.

      Select the tasks that members of this role can perform, and click OK to apply the changes.

See Also

Tasks

Connect to a Report Server in Management Studio

Concepts

Create and Manage Role Assignments

Reporting Services in SQL Server Management Studio (SSRS)