Help with roles in SQL Server Reporting Services 2005

Hot Topic

send mail task error
SSIS doesn`t start after applying SQL Server 2005 SP1 error Message 7000 Service Control Manager
Copy table from ODBC to SQL database
Migration of SQL Serve r2000 packages
Rebuilding dimensions with huge fact tables
Images on a report
ReportService2005.asmx
Common Table Expressions!
Adding values to DropDownList populated by Query
Privileges for Deploying Reports

SQL Server

T-Log Backups fail from 7am to Noon
How to fit report perfectly in Report Viewer in WebParts
SQL 2005 Enterprise June CTP Installation Error
Management Studio and Mangement Studio Express on the same machine
Which Raid for SQL 2005
SqlServer 2005: How to test Cube Actions
Multi Threading exception
Distributing database with app
Assigning XML data to variables
SQL2005

Help with roles in SQL Server Reporting Services 2005

I know how to create roles but how do you add users to them, and then roles to different levels  This section of MSDN doesn't tell much

http://msdn2.microsoft.com/en-us/library/ms157397(en-US,SQL.90).aspx



Answer this question

Help with roles in SQL Server Reporting Services 2005

  • JakeG1018

    You add users to the roles by navigating to the item you wish to secure.  You then click on the property tab, then the security sub-tab.  From here you can click on 'New Role Assignment'.  Now you can add a user or group and assign the role you wish for them to have on this item. 

    You can also do this at the site level for the site level permissions. Click on 'Site Settings' in the upper right hand corner. Then click on 'Configure site-wide security'.  From here you can again add users and assign them different system roles.

    -Daniel

  • Help with roles in SQL Server Reporting Services 2005
Answer this question