Introduction to SSAS Security in Analysis Services

SSAS Security

• SSAS BIDS level it supports ‘role based’ security
• User (or) group assigns to a Role, each role contains set of responsibilities. (objects privileges – access, Read, write)

Eg:-     VINAY/DWTH                                                    ——– user/Group

↓

Tester                                                                 ——-  Role

↓

Functional testing writing test                  ——- Responsibilities

Cases etc…..

Eg:- Creating two roles (developer_SSAS, Tester –SSA with different objects and different privilege and observing the result.

1. Solution Explore → Roles → Roles → RC → New Role →

General

Role name:         Developer _Role_SSAS

Role Description: Developers has full  privileges

• Full Control (Administrator) Membership

Add  → CLICK → Enter the object names to select → VINAY → CHECK NAMES → OK

Note:

In ss 2005, even we select full control, we can edit objects and its security. That means the tabs (data sources, cubes ___) enabled for operations.

IN 2008, full control option disables remaining tabs.

2.  Role → New Role → General

Role Name: Tester __ Role__ SSAS

Role Description: No privileges to Lester (or)

Process database limited privileges membership

Add  → Madhu → check names → Data sources

DS_Text tiles 1                  Read

DS_Texttiles 2                   None

Cubes

Textiles –Cube Read Drill through

ETC,……………

3.  DEPLOY, GO TO CUBE BROWSER, Reconnect

4.  Click Change user icon → roles → Developer—role—SSAS & See the result

5.  Roles → select → tester_role_SSAS and observe

Enroll for Instructor Led Live Online MSBI Training

---