Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jonathanNXTG
Starting Member
8 Posts |
 Posted - 2005-11-24 : 05:15:36
|
Active DirectoryHow does sqlserver knows to wich active directory groups a user belongs.The solution should compare a groupname with the groupnames of the current user and return a bit.This way a single bit can tell if the current user belongs to a predefined group. |
|
|
cfederl
Starting Member
26 Posts |
Posted - 2005-11-25 : 17:00:51
|
| There is an extended stored procedure you could use to return a logins groups:exec master.dbo.xp_logininfo @acctname = 'aausa\carl.federl' , @option = 'all' Alternatively, LDAP can be defined as a linked server although this is usually to Active Directory.Carl Federl |
 |
|
|
|
|
|
getting user group from Active Directory