如何从Active Directory用户组查询用户 [英] How to query users from an Active directory user group

问题描述

亲爱的人

我有一个问题，想在Azure上使用SQL Server实施基于角色的安全性.我想从连接到数据库的AD组中查询用户.

I have a question for implementing role based security with SQL Server on Azure. I would like to query the users from an AD group that is connected to the database.

有没有办法查看哪个用户是该组的成员，我知道有一个名为IS_MEMBER的功能，但是我想查询AAD组中可用的帐户.

Is there a way to see which user is a memer of the group, i know there is an function called IS_MEMBER, but i want to query the accounts available in the AAD group.

让我们说.

Azure AD组中的

名为:AAD_ALL_USERS_THAT_GOT_ACCESS

in the Azure AD Group named: AAD_ALL_USERS_THAT_GOT_ACCESS

拥有多个AAD用户帐户:

holds several AAD user accounts :

• domain \ [e-mail]
• domain \ [e-mail]
• domain \ [e-mail]

如何从Azure SQL查询组中的用户:"AAD_ALL_USERS_THAT_GOT_ACCESS"

How can i query from Azure SQL the users from the group: "AAD_ALL_USERS_THAT_GOT_ACCESS"

预先感谢

迈克

推荐答案

亲爱的我会根据我在用户表中有关有效和无效帐户的信息来完成此操作，因此无需费时Azure中的AAD信息，但是为什么很难找到关于此主题的示例.

Dear all I will do it based on the information i have in a user table about active and inactive accounts so no need to fertch the AAD information in Azure, but why is it so hard to find examples about this topic.

此致

迈克尔




这篇关于如何从Active Directory用户组查询用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！