October 12, 2006 at 12:38 pm
I am having trouble with the security settings in SQL Server 2005. I have one database that has a series of views that look at several other DB's. I had a problem at first allowing users to view reports using reporting services, I got around this by making all of the users to db_datareaders on each DB. However now that I am using some reports that have SQL behind them that creates Temp Tables, these permissions are no longer working. Does anyone have any suggestions on how to allow the minimum amount of security that will allow my users to view published reports? It only work if I go into SQL Server 2005 and make that user a sysadmin under Server Roles in the security folder for the DB.
November 30, 2006 at 7:52 am
We have also encountered this problem. Our work-around was to create credentials for a dummy user with dbo access. This provided the access for users to run stored procedures behind the scenes. Does anyone have any other suggestions?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply