SQL Server Performance

Can I use roles to hide reports?

Discussion in 'SQL Server Reporting Services' started by JanneH, Feb 9, 2004.

  1. JanneH New Member

    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


  2. jasper_smith New Member

  3. dmatta59 New Member

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

    dmatta
  4. jasper_smith New Member

    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

Share This Page