Understand role of Report Manager in SSRS Service

Understand role of Report Manager in SSRS Service

Tasks that can be performed by the Report Manager.

• Creating, deleting, and modifying folders
• Assigning users (or group) to roles and permissions to access reports
• View, print, and search
• Windows user access to a report on the Report Manager
• Deploying reports
• Creating a new data source and generating a model using Report Manager
• Downloading a report definition file from the Report Server
• Working with report cache
• Working with standard, email, file share, and data-driven subscriptions

Report is deployed (published),the detailed information about all objects will get into the Report Catalog.

Report Catalog node in your Report Server in the SQL Server Management Studio

  • A listing of the objects in the dbo.Catalog table

There are two types of roles:  system-level and item-level.
System-level role assignments apply to system wide tasks whereas Item-level role assignments range over tasks that covers all content related tasks like, publishing reports, viewing reports, creating subscriptions and so on.

Default Role:
System User: View system properties and shared schedules.;
System Administrator View and modify system role assignment, system role definitions, system properties, and shared schedules.
Browser: May view folders, reports, and subscribe to reports.
Content Manager: May manage content in the Report Server including folders, reports, and resources.
My Reports: May publish reports and linked reports, manage folders, reports, and resources in a user’s My; Reports folder.Publisher May publish reports and linked reports to the Report Server (manage models, manage data sources)
Report Builder: May view report definitions.
Custom Role: Pick and choose tasks.

Note: Custom role you will be creating will get into the ROLES table in the Report Server Database


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.