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
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
SSIS | Power BI |
SSRS | SQL Server |
SCCM | SQL Server DBA |
SharePoint | BizTalk Server |
Team Foundation Server | BizTalk Server Administrator |
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
MSBI Training | Mar 25 to Apr 09 | |
MSBI Training | Mar 28 to Apr 12 | |
MSBI Training | Apr 01 to Apr 16 | |
MSBI Training | Apr 04 to Apr 19 |
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
1 /15
Copyright © 2013 - 2023 MindMajix Technologies