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.



Row Filter


Members assigned to this role can query the data


Read and process

Members assigned to this role can query the data. In addition, they can execute commands to process the model.



Members assigned to this role can ...

Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.