Sunday, March 11, 2012

Active Directory / Groups + MS SQL (yikes)

When configuring ms sql to permit authentication from users over a
domain. Is it possible to poll from system tables like sysusers /
sysmembers / sysgroups / etc what active directory group's a specific
user is a member of once they are authenticated into a ms sql server?
I've been searching the newsgroups looking for a solution but so far
I'm unavailable to find any solutions. Any input would be greatly
appreciated.
Thanks,
Hi.
Try wit the IS_MEMBER function
Regards
Antonio Soto
Solid Quality Learning
<jebuskrust@.gmail.com> escribi en el mensaje
news:1140634046.553729.223840@.f14g2000cwb.googlegroups.com...
> When configuring ms sql to permit authentication from users over a
> domain. Is it possible to poll from system tables like sysusers /
> sysmembers / sysgroups / etc what active directory group's a specific
> user is a member of once they are authenticated into a ms sql server?
> I've been searching the newsgroups looking for a solution but so far
> I'm unavailable to find any solutions. Any input would be greatly
> appreciated.
> Thanks,
>
>

No comments:

Post a Comment