Its easy to create custom role in SSRS using SQL Server Management studio.
These are the browser permission for SSRS report manager. Similarly every role permissions can be able to view by right click on respective role and click on properties.
Content Manager :
Content manager has the highest level permissions under the Roles folder . For Content manager all the check boxes are checked in the above picture . The means user with content manager can able to view ,delete ,modify and publish the reports and subscriptions.
Publisher:
Publisher role is used for publishing the reports. This role also can be used for managing data sources. There are several ways to publish reports.
Click here to know the different way to publish the SSRS reports.
My Reports :
My reports role is generally used to manage the report created by individual user.
Report Builder :
This role is generally used to manage the report using report builder. User can able to view the reports using the report builder.
First SSMS need to open with run as administrator. Right click on SSMS >>> Run as adminstrator
The windows operating system i used here is Windows 8.
Then select Reporting services and click on connect
Make sure report services are running on the system. To check go to services.msc
Check SQL Server Reporting Services are running .if it is stopped. Right Click on the service and click on start.
Once we connect the SQL Server. under security folder there are two folders called roles and system roles.
This means there are two level permission
- Browser : This role is used to view the reports and folders and its hierarchies. It also used to manage the individual subscriptions. Browser permissions can be viewed by using right click on browser role. Click on Properties.
Content Manager :
Content manager has the highest level permissions under the Roles folder . For Content manager all the check boxes are checked in the above picture . The means user with content manager can able to view ,delete ,modify and publish the reports and subscriptions.
Publisher:
Publisher role is used for publishing the reports. This role also can be used for managing data sources. There are several ways to publish reports.
Click here to know the different way to publish the SSRS reports.
My Reports :
My reports role is generally used to manage the report created by individual user.
Report Builder :
This role is generally used to manage the report using report builder. User can able to view the reports using the report builder.
To create the Item level custom role Right click on role and click on new role.
Select the list of permissions form the below permissions.
- Click on OK. New role has been created.
- System Level (System roles)
- System Administrator :
S System Administrator role is predefined role which is mainly used managing the reports. Job scheduling, Report execution (RSEXEC role under Reportserver database) subscriptions on system level and also able to execute the role without publishing the reports into report server. The below diagram shows the list of permission that will be available to System administrator by default.
S Similarly System user permission also can view by right click on the System user.
S Custom roles also can be created from the list of above permissions. Its similar to the above item level customer roles.
Report server database and system table details found here
No comments:
Post a Comment