I ran into a bit of an odd situation. Let's say I have a domain group [DMN\Group] which has been created as a login on my server and a user in the database. One of the members in that group is not getting the permissions that have been assigned to the group. What's odd to me about this situation is that when I do
exec xp_logininfo 'DMN\Group', 'members'
the user shows up. However, when I do
exec xp_logininfo 'DMN\user', 'all'
the group doesn't show up as a permission path. How can this happen? And, perhaps more importantly, how can I fix it?