So you only want them to have permission to run the report? If so, you can make them a part of the Report Viewer group in SQL Server Reporting Services (SSRS).
You also mention Management Studio... Do these people need to have permission to modify the actual databases?