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 process the model only |
No |
|
Administrator |
Members assigned to this role have full control and can query the data |
No |
There is one additional permission: None, which does not allow anyone to view or process the model. If required, you could configure...
