Dynamic user security in Reporting Services

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?

Jul 13 '09 #1

Subscribe Post Reply

2818

Jerry Winston

145

Expert 100+

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.

Jul 29 '09 #2

mbewers1

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

Matt

Jul 29 '09 #3

by: BMM | last post by:

Hi. I am involved in a project that I think is a perfect candidate for an SVG-based implementation (web-enabled, data-driven). However, a subcontractor has suggested that SVG is not the way to go....

.NET Framework

Convert variable into dynamic select

by: Rodusa | last post by:

I am trying to assign @sql variable to @total, where @sql is a sql statement stored on the database, however what I am getting is its string value and not its calcuation. Could anybody help? ...

Microsoft SQL Server

Events not firing (First time only) in a dynamic user control. Please help.

by: Shourie | last post by:

I've noticed that none of the child controls events are firing for the first time from the dynamic user control. Here is the event cycle. 1) MainPage_load 2) User control1_Load user clicks a...

ASP.NET

MS SQL Server 2000 Reporting Services

by: Woody Splawn | last post by:

I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a...

Visual Basic .NET

Reporting Services 2000 & 2005 on same machine

by: rmk | last post by:

How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio...

Microsoft SQL Server

Active Directory User Name from Logon Name

by: Arthur | last post by:

Hi All, I would like to get the name of the user given their networkID, is this something Active Directory would be useful for?(For intranet users) If so, can you please point me to some sample...

C# / C Sharp

Getting logged in user from a service?

by: JamesB | last post by:

I am writing a service that monitors when a particular app is started. Works, but I need to get the user who is currently logged in, and of course Environment.UserName returns the service logon...

C# / C Sharp

SQL Reporting Services Security

by: Just Me | last post by:

Hey Peeps, My exisiting scenario is SQL2000 with no reporting services, and we use Microsoft .NET 2003 and Crystal reports to report. This works reasonably ok. As the ASP.NET application uses...

ASP.NET

Is there any security threat if using Crystal Reports?

by: HaVeN | last post by:

When deciding on what Reporting Services to go with.. Security is of importance when deciding. I'm developing a ASP.NET website that will require the use of reports and the instructor had told me "DO...

.NET Framework

Steps manually installing IntelliJ IDEA.

by: erikbower65 | last post by:

Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...

General

Development of Funny H5 Game - Toy Claw

by: kcodez | last post by:

As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...

HTML / CSS

Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

To verify entry of a dropdown

by: DJRhino | last post by:

Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...

Microsoft Access / VBA

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How does React native implement an English player?

by: lllomh | last post by:

How does React native implement an English player?

Mobile Development

How to calculate date of retirement from date of birth

by: Mushico | last post by:

How to calculate date of retirement from date of birth

Data Management

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Dynamic user security in Reporting Services

Similar topics