Can I use roles to hide reports? | SQL Server Performance Forums

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 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 HTH Jasper Smith