Have a look at xp_logininfo, it'll do what you need.

-----Original Message-----
From: Martin A. Jones
[mailto:mssqldba-ezmlmshield-x38556534.[Email address protected]
Sent: Wednesday, March 28, 2007 2:48 PM
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



------------------------------------------------------------------------------
NOTICE OF CONFIDENTIALITY
The information contained in this communication and any accompanying document(s) is proprietary and confidential and is intended solely for the above-named individual or entity. If you are not the intended receiver, recipient or entity, you are advised that any distribution, copying, disclosure or communication of this email is strictly prohibited. If you have received this email in error, please contact me at the telephone number listed above or 858.716.1500.
==============================================================================


MS Sql Server LazyDBA home page