O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required