This article will explain to modify security settings for Report Server application and for a specific report by using the Microsoft SQL Server Reporting Services Web application interface.
SQL Server Reporting Services is a Web application and is administered by using a browser
a. Click Start | All Programs | Internet Explorer.
b. In the address bar, type http://localhost/Reports and press ENTER.
c. In the upper-right corner of the browser screen, click the link for Site Settings.
d. In the Security section near the bottom of the page, click Configure system-level role definitions.
e. Click the New Role button near the top of the page.
f. If an Internet Explorer error appears, dismiss it by clicking OK.
g. In the Name text box, type Report Analyst.
h. In the Description text box, type May view server properties and manage shared schedules.
i. In the Select one or more tasks to assign to the role section, select Manage shared schedules, View report server properties, and View shared schedules.
j. Click OK to save the changes.
Access to a report can be fine-tuned for specific groups or users by creating item-level roles that grant different permissions from the default permissions created when a report is first deployed.
a. Click Site Settings.
b. Under Security, click the Configure item-level role definitions link.
c. Click the New Role button.
d. In the Name text box, type ReadOnly.
e. In the Description text box type May only view server objects.
f. Select the check boxes for View data sources, View folders, View reports, and View resources, and then click OK
g. Click the Home link, click On the earlier developed Report from the Report Project for which you want to change the permission, and then click AWSales.
h. Click the Properties tab. On the left-hand side of the screen, click the Security link, and then click the Edit Item Security button at the top of the window.
Permissions are inherited from their parent folder by default. Changing the default permissions opens an information dialog box asking the user if they want to break the inheritance of these permissions.
i. In the Microsoft Internet Explorer message box, click OK.
j. Click the Edit link to the left of the BuiltIn\Administrators label. Clear all selected items, check the ReadOnly box, and then click Apply,
k. Close Internet Explorer.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|