This chapter assumes that, while your responsibilities are mostly concerning the SQL Server database engine (the relational engine we have covered in all previous chapters of this book), you also have to administer or maybe create some BI structures such as Analysis Services cubes or Reporting Services reports. We assume that if you were only specialized in SQL Server BI, you wouldn't have bought this book in the first place, and would have rather chosen a dedicated BI book. But being a SQL Server Database Administrator involves sometimes dealing with its BI components.
The security mechanisms of the SQL Server BI tools are less complex than the relational engine ones, and that is why a single chapter is enough to give you a sense of how to do things and enough information to do a reasonable job. In other words, we will effectively cover what needs to be covered to secure SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and we will finally cover the...