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 - SQL Server Tutorial
From the course: SQL Server 2008 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.