连接到Azure SQL数据库时Azure Analysis Services中的动态安全性 [英] Dynamic Security in Azure Analysis services while connecting to Azure SQL Database

问题描述

我们正在 Azure SQL数据库上构建Azure Analysis Services模型. 以直接查询模式查询数据.我们要实施 此模型中的动态安全性.我们已经在SQL DB中安全化了视图，该视图基于user_name()过滤数据.但是，在Analysis Services中，我们能够设置连接字符串的唯一方法是使用SQL登录名.我们无法使用 Windows登录，因此，AAS传递给数据库的userID始终是连接字符串中的SQL用户，而不是访问多维数据集中数据的用户.

请提出如何解决此问题的建议.

预先感谢.

解决方案

您好，

请检查一下: 

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.

这篇关于连接到Azure SQL数据库时Azure Analysis Services中的动态安全性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！