Security Model for Analysis Services - Microsoft SQL Server 2008 Analysis Services - page 721

Server

Administrators
Role

DataSource

DataSource
permissions

Database

Database
permissions

Cube CubeDimension

Cube
permissions

CubeDimension
permissions

Role

Dimension Attribute

Dimension
permissions

Attribute
permissions

MiningStructure

MiningStructure
permissions

MiningModel

MiningModel
permissions

FIGURE 35.5 Hierarchy of permission objects.

LISTING 35.3

DDL to Create a BudgetCubeUsers Role

<Alter AllowCreate=”true” ObjectExpansion=”ObjectProperties”
➥ xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
<Object>
<DatabaseID>FoodMart 2008</DatabaseID>
<RoleID>Role</RoleID>
</Object>
<ObjectDefinition>
<Role xmlns:xsd=”http://www.w3.org/2001/XMLSchema”
➥ xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>
<ID>Role</ID>
<Name>BudgetCubeUsers</Name>
<Members>
<Member>
<Name>MyUser</Name>
</Member>