Connecting Tech Pros Worldwide Forums | Help | Site Map

Dynamic user security in Reporting Services

Member
 
Join Date: Feb 2009
Location: Jersey
Posts: 35
#1: Jul 13 '09
I'm creating a SSRS project and would like to know if it is possible to configure the security features for the project such that only a certain group of users can view each report and so that not every user can view every report in the project.

I have looked at the Role Assignment page in the Report Server management webpage and read the SQL Server Reporting Services book by Wrox programmers:

http://books.google.co.uk/books?id=A...&safe=on&hl=en

, but can't find my answer there.

Please advise if this is possible?

Newbie
 
Join Date: Jun 2008
Posts: 25
#2: Jul 29 '09

re: Dynamic user security in Reporting Services


Definetly,

SSRS directory and report viewing security can be controlled by ActiveDirectory. you can grant the various SSRS user roles to a specific user or group. ie.

MYDOMAIN/User
-or-
MYDOMAIN/SomeGroup

You can further customize SSRS by creating new roles within SSRS.
Member
 
Join Date: Feb 2009
Location: Jersey
Posts: 35
#3: Jul 29 '09

re: Dynamic user security in Reporting Services


Thanks, I'll take that on board and try out these settings in Report Manager

Matt
Reply