Implement Roles in a SSAS Tabular Cube

preview_player
Показать описание
Get my Modern Data Essentials training (for free) & start building more reliable data architectures

-----

Roles in tabular models define member permissions for a model. Members of the role can perform actions on the model as defined by the role permission. Roles defined with read permissions can also provide additional security at the row-level by using row-level filters.

In this video we will review how to add roles to your tabular model project using the Role Manager in Visual Studio.

Timestamps:
0:00 - Intro
0:11 Adding Roles in SSMS
0:43 Accessing the Role Manager
1:25 Create a New Role
4:01 Review Results
5:15 Testing More Changes
6:19 Closing

Title & Tags:
Using Roles in a Tabular Cube | SQL Server Analysis Services (SSAS) Tutorial
#kahandatasolutions #ssas #dataengineering
Рекомендации по теме
Комментарии
Автор

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

KahanDataSolutions
Автор

Great content! Would like to see more advanced SSAS tutorials on Tabular models, Real time scenarios, troubleshooting etc. I enjoyed the bite size tutorials! Thanks!

syedislam
Автор

Thanks a lot. Very helpful and well explained

anurag
Автор

Do you need to have a database login to use SSAS?

CaribouDataScience
Автор

Superb SSAS quick learning & recap videos.. 🙏🏻🤝

udaythakur
Автор

thank you for this awesome course, am having challenges with permission in creating a sql server agent job, how do i relate my challenge in order to get assistance pls

Eko-owaiLawrence
Автор

Hello, I would like to know which version of visual studio you are using in this video?
because for my part, I would like to hide columns for a specific role, but I do not have the "Tables and column" tab.

MrIsma
Автор

it would be useful if we can update the role in analysis service sever through a job because the roles in my case changes everyweek

looklook
Автор

Is it possible to set cube-level permissions for tabular models? I can't see the "Cube" pane in roles wizard..

misiael
Автор

i have created one role level security but i am getting rows which should not ...please suggest me.. i am using visual studio 2019

moulabeenetturi