2008 sql reporting server security restrictions

Is there a way of restricting users from exporting certain reports? etc i.e. financial data from reporting site? Again, I do not want to restrict all reports - this should be just for certain sensitive reports. Is this restriction possible to implement and what are the steps involved?  

Also, how do I implement a legal disclaimer which users have to accept before proceeding to the reporting home page ?
EKITAAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
for that you have to create other application from where user can restricted as per you requirement.

But from Report manager you cannot restrict for some user for some permissions as you specified. i.e. 2 users can view report but cannot download. If you wish you can do it for all.
0
 
edtechdbaCommented:
Are users running these reports using SSRS Report Manager? If so, then yes you can set permissions for users to view the report. Not sure about allowing report viewing and not downloading, if I'm not mistaken, I think that's an all-in-one permission (running/viewing and downloading). These permission settings can be found in the properties setting in the reports that have been deployed to the report manager.
0
 
Vijay Pratap SinghCommented:
Hi this can be achieved by making certain roles and assigning users accordingly.

http://www.idevelopment.info/data/SQLServer/DBA_tips/Reporting_Services/REPORTING_5.shtml

this article for reference
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
EKITAAuthor Commented:
guys,

the part you've outlined is working fine. Users have permissions to view reports. We want to take it a bit further and restrict the exporting of certain reports. i.e. although a user has been assigned permission to run/view a report. We want to restrict that users ability to then export the data into word, PDF, excel, csv etc.
0
 
edtechdbaCommented:
Here's a hack that someone put together to hide report export options in the SSRS report manager, maybe this will give you some ideas.

http://mikemason.ca/blog/2007/04/disabling-export-formats-in-reporting-services/
0
 
EKITAAuthor Commented:
Not really a solution but acceptable answer.
0
All Courses

From novice to tech pro — start learning today.