Chapter 11: Securing Your SSAS Models
Now that we have created our models and built reports and dashboards, we will wrap up the book with chapters on security and maintenance. This chapter focuses on securing the server and the data in your models. We will review the capabilities that SQL Server Analysis Services (SSAS) brings and the unique features available to each type of model. A significant part of this chapter will describe what you can do to implement different or enhanced security. Some of the topics in this chapter will not have hands-on exercises because of the complexity or enterprise nature of security implementations.
In this chapter, we're going to cover the following main topics:
- Reviewing security settings for SSAS
- Setting up user roles in servers and databases
- Implementing data security in multidimensional models
- Implementing data security in tabular models
