更新时间:2022-11-28 19:56:27
您好,
请检查一下:
https://docs.microsoft.com/zh-CN/azure/analysis-services/tutorials/aas-supplemental-lesson-dynamic-security
让我知道是否有帮助,否则我们可以继续进行对话.
Hi,
We are building an Azure Analysis Services model on Azure SQL database to query data in a direct query mode. We want to implement dynamic security in this model. We have securitized views in SQL DB that filters data based on user_name(). However, in Analysis Services, the only way we are able to set up a connection string is using a SQL login. We are unable to use the Windows Login and as a result, the userID passed to the DB by AAS is always the SQL user in the connection string and not the user who is accessing the data in the cube.
Please suggest how I can resolve the issue.
Thanks in advance.
Hi,
Please check this out :
https://docs.microsoft.com/en-us/azure/analysis-services/tutorials/aas-supplemental-lesson-dynamic-security
Let me know if this helps or else we can gladly continue the dialogue.