question

Sahoo-9422 avatar image
0 Votes"
Sahoo-9422 asked CarrinWu-MSFT commented

SSAS Tabular cube role will be accessed dynamically based on the user table

Hi Team,

We have created one SSAS tabular cube and defined role in that cube.

Our Requirement is"

We are maintaining one sql server table for the users . Users will be added dynamically to the table whenever the new user inserted into the table then automatically same user will be accessed the role defined in the cube.

We don't have relation to cube tables and user table.

How can i achieve these one?

sql-server-analysis-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Sahoo-9422, we have not get a reply from you. Could below answer help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

Hi @Sahoo-9422, any update for this thread?

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @Sahoo-9422,

Dynamic security might be help you to achieve this. It is a technique that enables a single role to apply different permissions for different users. It’s useful when you would otherwise be forced to create and maintain a large number of individual roles. Please refer to Implement Dynamic Security by Using Row Filters to get more information.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.