Searching AD group members from a SQL stored procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roberto Souza - 29 Nov 2006 13:32 GMT

Hi. We are creating a new app in wich we need to know if the user is member
of at least one of as list of AD groups. The user network login name is
provided to one stored procedure then it needs to query the AD to verify if
the string containing the user name is member of a list of its groups.
How can we make it? We searched for sp_'s and xp_'s but didn't find anyone
that could return this information.

Thanks in advance,

Roberto de Souza Santos.

Reply to this Message

Uri Dimant - 29 Nov 2006 13:38 GMT

Hi
Take a look at IS_MEMBER function in the BOL

> Hi. We are creating a new app in wich we need to know if the user is
> member of at least one of as list of AD groups. The user network login
[quoted text clipped - 7 lines]
>
> Roberto de Souza Santos.

Reply to this Message

Roberto Souza - 29 Nov 2006 14:12 GMT

The is_member function relates to the current user, I need to query for a
user name that is different from the current one.

Roberto.

> Hi
> Take a look at IS_MEMBER function in the BOL
[quoted text clipped - 10 lines]
>>
>> Roberto de Souza Santos.

Reply to this Message

jebuskrust@gmail.com - 30 Nov 2006 22:31 GMT

Setting up a sql server provider to connect to your ldap server and
using openquery to query it within a stored procedure is your friend.
Querying OU, samaccountname, name is your friend to get this
information is your friend. My advice though is to store the catalog in
a table within the database and using that table instead to make
query's to prevent your ldap server from getting soo much load.

Let me know if you need a more extensive reply :)

Good luck to ya

On Nov 29, 9:12 am, "Roberto Souza" <robertossan...@hotmail.com>
wrote:

> The is_member function relates to the current user, I need to query for a
> user name that is different from the current one.
[quoted text clipped - 15 lines]
>
> >> Roberto de Souza Santos.- Hide quoted text -- Show quoted text -

Reply to this Message