April 6, 2011 at 9:46 am
I have some reports that are for internal consumption only. Anyone in the company should be able to see them, however, the majority do not have access to the cubes. Can I set up the reports security so that no matter who clicks on the reports they can see them? How would I do this? Can I do this?
April 6, 2011 at 3:37 pm
You can use stored credentials to bypass the user credentials for access to the database. However, you will have to be careful to organize the reports in a way that will enable you to grant viewing access only to those users that require it.
Not too difficult, but will take some thought.
April 7, 2011 at 4:01 pm
The method I used in this scenario was to use a stored credential against specified reports. That credential was granted exec permissions against only the procs used by those reports for an additional layer of security.
April 18, 2011 at 8:15 am
How/where would I set up stored credentials? How would you set up a stored proc? I am brand new at this and I don't understand what you are saying. Sorry!
April 18, 2011 at 8:46 am
The reports allow you to execute stored procs to generate the required data instead of defining queries. Instead of granting read permissions to every table used in the report(s) you could just grant exec permissions against the procs, which should be more secure.
The credentials are specified for data sources in Report Manager, either shared or custom on individual reports. One of the options is to connect using "Credentials stored securely in the report server".
In combination, it's possible to set up an id with database priveliges to see only these reports.
Does that help?
Matt.
April 19, 2011 at 9:39 am
jsturgeon 49541 (4/6/2011)
I have some reports that are for internal consumption only. Anyone in the company should be able to see them, however, the majority do not have access to the cubes. Can I set up the reports security so that no matter who clicks on the reports they can see them? How would I do this? Can I do this?
As I got you: Go to your Report Server, open folder with Reports, select Properties, Security, New Role Assignment and Add Group (e.g. company domain) or particular User. All Users from company Domain will have access to Reports.
April 19, 2011 at 9:40 am
I got it to work. Thanks.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply