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