Database Reference
In-Depth Information
Implementing security in Tabular
Models
One of the key differentiators or reasons to move Power Pivot models into SQL Server
Analysis Services is security. Tabular Models support a much more robust security
model than what is available in Power Pivot in Excel or SharePoint.
Getting ready
In order to work with security, you will need some users that you can assign to the
roles. In my solution, I have added
SteveReader
and
SteveFiltered
to my local
computer. Normally, you would be using Active Directory users and groups to man-
age your security. If you have a test or development environment with users at your
disposal, use them. In either case, you will need users to complete this next recipe.
How to do it…
You can open the
Role Manager
dialog by clicking on the
Roles
button on the toolbar
or the
Roles
option in the
MODEL
menu item. This will open the
Role Manager
dia-
log. You will be creating a read-only role, which will prevent a user from reloading data
or making changes to the model:
1. This can be done by clicking on the
New
button, which will add a new role.
Rename the role
Read Only
and select the
Read
permissions from the dia-
log.
2. Next, click on the
Members
tab in the lower half of the dialog, and add the
user or group to which you want to give
Read Only
permissions to your mod-
el. Now the dialog should show your changes.
Note
As you likely would have noticed, there are other permissions available.
Here is a brief breakdown of these permissions and what they allow:
Search WWH ::
Custom Search