From the course: SQL Server 2008 Essential Training
Unlock the full course today
Join today to access over 22,600 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.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Introduction to SQL Server Reporting Services2m 52s
-
(Locked)
Connecting to the Report Manager4m 29s
-
(Locked)
Using Report Builder12m 3s
-
(Locked)
Formatting values in reports4m 17s
-
(Locked)
Adding indicators to reports5m 11s
-
(Locked)
Adding charts to reports3m 54s
-
(Locked)
Working with report security3m 54s
-
-
-