How to: Create, Delete, or Modify a Role (Management Studio)

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 SQL Server 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

Concepts

Creating, Modifying, and Deleting Role Assignments
Creating, Modifying, and Deleting Role Definitions
Report Server How-to Topics

Help and Information

Getting SQL Server 2005 Assistance