MSBI # 58 – SSAS # 15 – How to Defining Administrative Roles in SSAS

Hi friends,

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
  • In this post we are covering detailed explanation for How to Defining Administrative Roles in SSAS with following points

  • Granting Process Database Permissions
  • To define a Process Database Objects security role
  • 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.

    clip_image001

    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.

    clip_image002

    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

    Link Resource Website>> Dactylonomy of Web Resource

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: