使用sql查询用户的活动目录组 [英] Using sql to query the active directory groups of a user

问题描述

大家好

我正在尝试在sql 2008中编写查询，该查询将返回活动目录中列出的当前用户组.

为此，我已经创建了一个到Active Directory的链接服务器，并且我正在连接到该服务器，甚至编写了基本的ldap查询.但是，我无法弄清楚如何编写ldap查询，该查询将从活动目录返回当前用户的组.

有人知道如何编写这样的ldap查询吗?

谢谢
Ben

Hello Everyone

I am trying to write a query in sql 2008 which will return the current user''s groups listed in active directory.

To do so, I have created a linked server to the Active directory and I am connecting to it and even write basic ldap queries. However, I wasn''t able to figure out how to write the ldap query which will return the current user''s groups from the active directory.

Does anyone know how to write an ldap query like this?

Thanks
Ben

推荐答案

是否

这篇关于使用sql查询用户的活动目录组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！