Posted by jebuskrust@gmail.com on 01/15/07 20:42

Marcin A. Guzowski wrote:
> Erland Sommarskog wrote:
> > Before I try anything, I would like some clarification. With "groups" do
> > you mean what is normally called "roles" in SQL Server? That is grouping
> > of users within a database?
> >

Question #1:

Answer : Yes

sp_helpuser

> > Or do you mean Windows groups as in DOMAIN\OFFICEUSERS?
>
>
> Even if Arman meant roles, I'd like to ask you similar question
> according to Windows groups. Is it possible to list Windows group
> members using T-SQL? Let's assume that I'm a sysadmin, but not domain
> admin.
>
>

Question #2:

Answer: Yes, set up a linked server with your pdc server / active
directory and use open query to query this information from the linked
server.

http://www.fits-consulting.de/blog/PermaLink,guid,1e768aef-9ae5-4e60-9dad-2f2e73b00faa.aspx

> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

[Back to original message]