From the course: SQL Server 2008 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Working with report security

Working with report security - SQL Server Tutorial

From the course: SQL Server 2008 Essential Training

Start my 1-month free trial

Working with report security

When you get your reports to a point where you don't mind to sharing it with someone else, well you're going to have to share it with someone else. And most of this is done through the SQL Server Reporting Services Report Manager web site, and if I selected the report that I've created and click the drop-down box I have a whole bunch of different options here. We've seen Edit in Report Builder, but I can also click Security or go to the more generic Manage. Manage would allow me to change things like the Name and the Description if I wanted to. There is a whole series of other options, most of which I can see because I am an administrator, things like the data sources, and you can also look at setting up subscriptions to report so that automatically push to people. But what I'm interested here is security. But something to bear in mind about Reporting Services security is it's kind of like SQL security. There are wheels within wheels. And this report is contained inside the homepage…

Contents