O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11.  Securing Reports in Reporting Services

Security is a critical aspect in administrating your reporting server. In this chapter we'll learn about SSRS security through the following recipes:

  • Authenticating users for Reporting Services
  • Becoming a Report Portal System Administrator
  • Authorizing users for accessing reports via SSRS roles
  • Creating new roles in Reporting Services
  • Editing existing roles in Reporting Services
  • Filtering data for the current user
  • Handling security on shared data sources
  • Securing the channel using certificates

Introduction

In this chapter, we'll discuss the various layers of security built into Reporting Services. We'll begin with a look at how SSRS authenticates a user, followed by recipes for determining what a user ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required