Pages

Men

rh

4/22/2012

Roles in SSRS

There are Two types of roles in SSRS. Item Level Role and System Level Role to which users or groups assigned.

Item Level Role: 
In SSRS, Item Level Role definition reference to the set of permissions, also called tasks, related to  the server's content. The content include either with Report Builder or with BIDS, Subscription, data sources, folders, report snapshots.

There are five types of Item level role
  • Browser
  • Content Manager
  • My Reports
  • Publisher
  • Report Builder
Creating a New SSRS Item Level Role in SSMS:
  • Open SSMS and then connect to Reporting Services.
  • In the Object Explorer, expand the Security Folder, and then Right click the Roles Sub folder and select New Role.


  • In the New Role dialog box, type a name and a description for the new role.
  • Select the check boxes for several task items that the role should have access to perform.
System-Level Role :
In SSRS System-Level Role definition reference the set of permissions, or tasks, related to the server Administrative objects and scope outside the report object hierarchy.

There are Two types of System Level Roles in SSRS as follows.
  • System Administrator
  • System User
 Assignment of System Administrative Role gives the users the capability to manage the roles and security, manage the server properties, manages the schedules and jobs, and execute reports. System Administrative users are allowed to view server properties and shared schedules and execute properties.

Creating New System Level Role in SSRS:
  • Open SSMS and then connect to Reporting Services.
  • In Object Explorer, expand the Security Folder, and then right click the System Roles Sub folder and then select New System Level Role.

  • Type a name and description for the new role.
  • Select the check boxes for the system task item that the role should have access to perform.






No comments :

Post a Comment