Hi Marty, You can create a linked server with the active directory
And then get the right information

Try right clicking on Linked servers, adding a new linked server.

Select other datasource, chose ADSDSOObject as the Provider name.
Then in product name put "Active Directory Service Interfaces"
Datasource = "adsdatasource"
Then in the Security tab click "Be made without using a security context"

Try that.


Jorge A.Vázquez

Sistemas Divisional


********************************************************************************
This communication may contain information that is proprietary, privileged, confidential or legally exempt from disclosure. If you are not a named addressee, you are notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so may be unlawful. If you have received this communication in error, please notify the sender via return e-mail and delete it from your computer. Thank you.
********************************************************************************


-----Original Message-----
From: Martin A. Jones [mailto:mssqldba-ezmlmshield-x38556534.[Email address protected]
Sent: Wednesday, March 28, 2007 14:48
To: LazyDBA Discussion
Subject: Active directory Security Groups

Is there a way with SQL to get the security groups that the user belongs
to? I have a application that uses Sql Server 2005 and has it's own
security module. If I can capture the active directory group or groups,
I then can determine what data they can access in the application by
mapping the two.

Thanks,



Marty





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page