SQL Server Performance Forum – Threads Archive

Can I use roles to hide reports?

Hi all,
I want to create the following user roles: Sales Manager Browse and view all reports
Purchaser Browse and view some reports
CashierBorwse and view one report What I want is to have one folder containing all reports and
depending on the user role the list only contains the reports
defined by the role. Anyone who knows how to achive this? Thanks in advance!
-Janne HasslÃ¶f

You can manage security using Report Manager. Reporting services has a role based security model. See ms-help://MS.RSBOL80.1033/rswork/htm/rms_security_v1_8kqb.htm in Reporting Services BOL
HTH Jasper Smith

Is there another referenece. This one is returning as an unknown?? dmatta

Have you got the Reporting Services Books On Line installed ? The link to the online version is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_security_v1_8kqb.asp The online version actually has new updated content not found in the copy that comes with the product. A downloadable update should be available soon but in the mean time the start page for it is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp HTH Jasper Smith

]]>