November 30, 2016 at 1:21 pm
I want to ask the following about sql server authentication on an SSRS 2008 report:
1. When the ssrs 2008 report is running, can sql server authentication be used for 'groups' of users? If so, would you show me how to setup these groups of users?
2. Also can there be individual user access within a group of users? For example if the 'group' is setup for 'Company X', can individual access be setup for each individual user within the group? Basically I would want each user to only have access to certain 'portions' of the reports? Would you show me the code and/or point me to links (urls) that will tell me how to accomplish this goal?
November 30, 2016 at 3:56 pm
For question 1, we use Active Directory permissions groups to assign access to folders in SSRS (in Folder Settings -> Security). For instance, the Accounting AD group has access to the Accounting folder where their reports are deployed. Access needs to be assigned to all folders all the way up; it wasn't enough to assign the Accounting group access to the Acct folder; they also needed access to the overarching Home folder as well.
For question 2, you can assign security to a report, but I don't know of a way to restrict access to only parts of a report. The only way I can think of is to have multiple versions of the report tailored to each user, and then give that user alone access to their version (not an optimal solution). Perhaps others will know better.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply