Content Manager Role

The Content Manager role is a predefined role that includes tasks that are useful for a user who manages reports and Web content, but does not necessarily author reports or manage a Web server or SQL Server instance. A content manager deploys reports, manages report models and data source connections, and makes decisions about how reports are used. All item-level tasks are selected by default for the Content Manager role definition.

The Content Manager role is often used with the System Administrator role. Together, the two role definitions provide a complete set of tasks for users who require full access to all items on a report server. Although the Content Manager role provides full access to reports, report models, folders, and other items within the folder hierarchy, it does not provide access to site-level items or operations. Tasks such as creating and managing shared schedules, setting server properties, and managing role definitions are system-level tasks that are included in the System Administrator role. For this reason, we recommend that you create a second role assignment at the site level that provides access to shared schedules.

Content Manager Tasks

The following table lists the tasks that are included in the Content Manager role.

Task Description

Consume reports

Reads report definitions.

Create linked reports

Create linked reports that are based on a non-linked report.

Manage all subscriptions

View, modify, and delete any subscription for reports and linked reports, regardless of who owns the subscription. This task also supports the creation of data-driven subscriptions.

Manage data sources

Create and delete shared data source items, view and modify data source properties and content.

Manage folders

Create, view, and delete folders, and view and modify folder properties.

Manage models

Create, view, and delete models, and view and modify model properties.

Manage individual subscriptions

Create, view, modify, and delete user-owned subscriptions to reports and linked reports.

Manage report history

Create, view, and delete report history, view report history properties, and view and modify settings that determine snapshot history limits and how caching works.

Manage reports

Add and delete reports, modify report parameters, view and modify report properties, view and modify data sources that provide content to the report, view and modify report definitions, and set security policies at the report level.

Manage resources

Create, modify, and delete resources, and view and modify resource properties.

Set security policies for items

Define security policies for reports, linked reports, folders, resources, and data sources. For more information, see Securable Items.

View data sources

View shared data source items in the folder hierarchy.

View reports

Run reports and view report properties.

View models

View models in the folder hierarchy, use models as data sources for a report, and run queries against the model to retrieve data.

View resources

View resources and resource properties.

View folders

View folder contents and navigate through the folder hierarchy.

Customizing the Content Manager Role

This role is intended for trusted users who have overall responsibility for managing and maintaining report server content. You can remove tasks from this definition, but doing so may introduce ambiguity into what can be managed. For example, removing the "View reports" task from this role definition would prevent a Content Manager from viewing report contents and therefore be unable to verify changes to parameter and credential settings.

The Content Manager role is used in default security. For more information, see Using Default Security.

Change History

Release History

12 December 2006

Changed content:
  • Recommendation regarding shared schedules.

See Also

Concepts

Configuring Security Through Role Assignments
Creating, Modifying, and Deleting Role Assignments
Setting System-Level Security
Item-Level Tasks
Predefined Roles Overview
Managing Permissions and Security for Reporting Services

Help and Information

Getting SQL Server 2005 Assistance