As SSAS is magical world between Dimension and Fact , But believe me its really more complicated when you understand more regarding SSAS
So lets continuing from my last practice post on SSAS
- MSBI # 41 – SSAS # 11 – How to Defining Calculations in SSAS
- MSBI # 42 – SSAS # 12 – How to Defining Key Performance Indicators (KPIs) in SSAS
- MSBI # 43 – SSAS # 13 – How Defining Actions in SSAS
- MSBI # 56 – SSAS # 14 – How to Defining Perspectives and Translations in SSAS
- Granting Process Database Permissions
- To define a Process Database Objects security role
In this post we are covering detailed explanation for How to Defining Administrative Roles in SSAS with following points
In this lesson, you learn to define security roles for administrative tasks
Granting Process Database Permissions
After you install an instance of Microsoft SQL Server 2005 Analysis Services (SSAS), all members of the Administrators local group are members of the Analysis Services Server role in that instance and have server-wide permissions to perform any task within the instance of Analysis Services. By default, no other users have any permission to administer or view any objects in the instance of Analysis Services.
A member of the Analysis Services Server role can grant users administrative access on a server-wide basis by making them members of the Server role, which grants them unrestricted access to all Analysis Services objects and data in that instance. A member of the Analysis Services Server role can grant users access on a more limited basis by granting them limited or complete administrative or access permissions at the database level. Limited administrative permissions include process or read definition permissions at the database, cube, or dimension level.
In the tasks in this topic, you will define a Process Database Objects security role that grants members of the role permission to process all database objects, but no permission to view data within the database.
To define a Process Database Objects security role
1.In Solution Explorer, right-click Roles and then click New Role.
Role Designer appears, as shown in the following image.
2.Click the Process database check box.
3.In the Properties window, change the Name property for this new role to Process Database Objects Role.
4.Switch to the Membership tab of Role Designer.
Notice that there are no users or groups in this role. You are just creating a role in this procedure. After deployment, an administrator can add users or groups to the role.
5.Switch to the Cubes tab of Role Designer.
Notice that members of this role have permissions to process this database, but have no permission to access the data in the Analysis Services Tutorial cube and have no local cube/drillthrough access, as shown in the following image.
6.Switch to the Dimensions tab of Role Designer.
Notice that members of this role have permissions to process all dimension objects in this database, and, by default, have read permissions to access each dimension object in the Analysis Services Tutorial database, as shown in the following image.
Hope this helps !!
Hope you have understood How to Defining Administrative Roles in SSAS and ready to use every aspects for same
If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog
If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog
Where todays links are
3 thoughts on “MSBI # 58 – SSAS # 15 – How to Defining Administrative Roles in SSAS”