How to create role assignments with SQL Server Reporting Services

SQL Server 2005 Reporting Services includes several predefined roles to accommodate different categories of users. You can see the roles defined in SQL Server Management Studio when you expand the folder roles within the security folder on the Report Server.

If you click on one of these roles and choose Properties from the list that appears, you will see details of the permissions of activities checked for that role.

Additional roles can be created if the default roles are insufficient. You can edit or delete either the predefined roles or the custom roles created, as long as they do not affect the last role assignment left for the report server. You can define a new role or edit an existing role in the SQL Server Management Studio Report Manager.

To create a role assignment in Report Manager, do the following:

  1. Go to the Contents page, and open the folder containing the item for which you want to apply a role assignment.
  2. Click the Properties tab, then click the Security tab, and do one of the following:

    a. If the article uses the security settings of a parent, click Edit Security Item, click OK, and then click New Role Assignment.b. If the item is already an item-specific security defined for it, click New Role Assignment.

  3. Type the name of a group or user account.

    Only one account name can be specified for each role assignment.

  4. Select one or more role definitions that describe how the user or group should access the entry, and then click OK.
  5. To determine which activities a role definition supports, click the name of the role definition.
  6. If there are insufficient role definitions, click New Role to create a new one.

Role definitions can contain either item-level or system-level task. It is not possible to combine activities of both levels into a single role definition. Since the number of operations you can work with is relatively small, a large number of role definitions are generally not required. Creating or editing a role definition requires careful consideration. If you also create many roles, the roles become difficult to maintain and manage.

Leave a Comment