Friday, December 4, 2009

SQL SSRS item level and system level roles

In sql 2005 we can specifiy item and system level role definitions. The item level and system level role definitions can be set by going http://localhost/reports

site settings --- Configure item level role definitions for item level
and Configure system level role definitions for system level

The item level role definitions are :
  • Consume reports
  • Create linked reports
  • Manage all subscriptions
  • Manage individual subscriptions
  • Manage folders
  • Mange reports
  • Manage models
  • Manage resources
  • Set security for individual items
  • View data sources
  • View models
  • View folders
  • View reports
  • View resources
But by default the sql 2005 provides only Browser, Content Manger, Report Builder, Publisher and My reports

The system level role definitions includes

  • Execute report definitions
  • Generate Events
  • Manage jobs
  • Manage report server properties
  • Manage roles
  • Manage shared shedules
  • Manage report server security
  • View report server
  • View shard schedules




1 comment:

  1. looks great. The parsing of corrupted documents can be also performed by the mdf recovery tool, it is the fastest way to open affected files

    ReplyDelete