Microsoft® SQL Server® 2012 Bible

1273

Chapter 56: Confi guring and Administering Reporting Services

56

Item-Level Roles

Item-level roles manage permissions associated with the reports, folders, and so on stored

in the report server. SSMS presents them in the Roles folder of the Object Explorer, with

the same functionality (right-click the role to edit, and then right-click the folder to add)

as used with system folders. Of course, the capabilities being granted differ as described in

the next section.

Managing Access with Roles

Whether you use the default role defi nitions or custom defi nitions, as described earlier, the

majority of security management occurs by assigning users to the proper role membership.

Granting System Access to Users and Groups

By default, the BUILTIN\Administrators group is assigned the System Administrator role.

Follow these steps to grant system access to additional users or Active Directory groups:

1. Start the Report Manager application by entering the appropriate URL into a
   browser.


2. Click the Site Settings link in the upper-right corner, and then choose the Security
   tab. A list of current users assigned to system roles displays.


3. Click the New Role Assignment button on the System Role Assignments page.


4. Enter the Group or User name — for example, myDomain\ jdoe or myDomain\
   SRSAdminstrators.


5. Select one or more system roles to assign to the group or user.


6. Click OK to save.

Assigning Item-Level Permissions

Item-level roles are used to control the tasks available for managing folders, reports, shared

data sources, shared datasets, models, and other resources in the Report Manager applica-

tion. Table 56-3 describes the default item-level roles created when the report server is

installed. You can use SQL Server Management Studio to modify or add to these roles, as

described in the preceding section.

TABLE 56 -3 Default Item-Level Roles

Task Browser Content Manager My Reports Publisher Report Builder

Consume reports X X

Create linked reports X X X

Manage all

subscriptions

X

Manage data sources X X X

Continues

c56.indd 1273c56.indd 1273 7/31/2012 10:34:18 AM7/31/2012 10:34:18 AM

http://www.it-ebooks.info