SSRS Security

SQL Server Reporting Services provides two level of security.
SSRS security can be managed from Report Manager. Click here, For more information on Report Manager.

System Level Security
    This level of security applies to whole server and  provides two roles under it.

1. System User
• This role is needed for viewing system Properties, Shared schedules and report builder.
2. System Administrator
• This role is super user role for administring SSRS.
• User under this can do following thinks
• System Role Assigmnents.
• Define System Role.
• Access Report Builder etc.

Item Level Security
    This level of security applied on all items on SSRS server like  Reports, DataSources, Datasets, Linked Reports etc.under a specific folder on report server.
     
    These roles can be used for differentiating users, if two different set of reports are deployed on same report server.

Following Roles come under this category.

1. Browser
•  Can only view reports, report folders and can subscribe to existing reports.
1. Content Manager
• User under this role is more like a item level administrator.
2. My Reports
• This role is more like a content manager restricted to a specific folder on reports server.
3. Publisher
• With this role one can develop and pulish reports and linked reports on to report server.
4. Report Builder
• This role allows viewing of report defination.