CHAPTER 11 SECURING REPORTS
Figure 11-22. Setting SQL Server stored procedure permissionsAuditing Reports
Having the ability to know the details of report execution, specifically for undesired access, is an
essential piece of the security puzzle. In this chapter, we are going to use the built-in report execution
logging and a report management table to build a report that will show up who ran what reports and
much more information. Having an audit trail of report execution is essential for gaining insight into
user behavior and possible security breaches.SSRS Auditing
In this section, we’ll show how to use the built in views in the ReportServer database to audit the
following in SSRS: