Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Managing roles

Each tabular model that you develop in Analysis Services can have unique permissions as required for your use cases. Permissions are assigned by implementing defined roles and associating Windows users or Windows groups to each role. In addition, you are able to limit the data that users can see by adding row-level filters.

In this recipe, you will be able to create a new role for four of the types of permissions that are defined in Analysis Services.

Permission	Abilities	Row Filter
Read	Members assigned to this role can query the data	Yes
Read and process	Members assigned to this role can query the data. In addition, they can execute commands to process the model.	Yes
Process	Members assigned to this role can ...