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