Microsoft® SQL Server® 2012 Bible

1274

Part IX: Business Intelligence

Task Browser Content Manager My Reports Publisher Report Builder

Manage folders X X X

Manage individual

subscriptions

XX X X

Manage models X X

Manage report history X X

Manage reports X X X

Manage resources X X X

Set security for indi-

vidual items

X

View data sources X X

View folders X X X X

View models X X X

View reports X X X X

View resources X X X X

Controlling Item-Level Security

By default, every item-level resource inherits the security settings of its parent. If the

security settings for an item have not been modifi ed (they still inherit from their parent

item), then the Security page for that item contains an Edit Item Security button. After

modifying the security settings (and breaking the inheritance from the parent item), the

Security page for the item contains item-level access to a user or group.

Best Practice

When inheritance has been broken, it can be complex to make broad changes to site-wide permissions.

Because of this, planning ahead for the folder hierarchy can be a big win. Keep the structure simple

so permissions can be granted on a few parent folders. For complex cases, it is sometimes easier to

use linked reports to provide appropriate access, rather than break inheritance.

Reporting Services roles are bundles of rights that are applied to users or groups for

each object. You must belong to a system role with the Set Security for Individual Items

task to complete these tasks. To edit an item level role’s security, perform the following

steps:

1. Select the item for which you want to modify security settings.

TABLE 56 -3 (continued)

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

http://www.it-ebooks.info