TimothyAWiseman
SSCrazy Eights
Points: 8819
More actions
July 9, 2008 at 9:45 am
#193689
In a server where permissions are assigned to Active Directory groups, is it possible to retrieve the group(s) that the current user is in without using CLR? system_user will return the login being used, but not the active directory group(s).
---Timothy A WisemanSQL Blog: http://timothyawiseman.wordpress.com/
MannySingh
SSChampion
Points: 12465
July 9, 2008 at 11:30 am
#840410
Do you want some like this:
exec master..xp_logininfo 'DomainGroupAccount','members'
This will list all the users in the domain Group, which is applied in the SQl Server.
Maninderwww.dbanation.com
July 10, 2008 at 2:32 pm
#841112
That works beautifully. Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply