|
Home > Archive > MS SQL Server security > November 2005 > Listing members of NT Group login
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Listing members of NT Group login
|
|
| MSSQLServerDeveloper 2005-11-03, 8:23 pm |
| Does anybody have any experience with listing all the members who belong to a
login that is a Windows Authenticated group using SQL Server 2k. My hunch is
that I will probably have to write some .net code using the activedirectory
namespace. anybody??
| |
| Jasper Smith 2005-11-03, 8:23 pm |
| exec xp_logininfo 'domain\group','memb
ers'
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
" MSSQLServerDeveloper
" < MSSQLServerDeveloper
@discussions.microsoft.com>
wrote in message news:4D2CBEAB-6E96-46CE-B088- D7EBDCACAA11@microso
ft.com...
> Does anybody have any experience with listing all the members who belong
> to a
> login that is a Windows Authenticated group using SQL Server 2k. My hunch
> is
> that I will probably have to write some .net code using the
> activedirectory
> namespace. anybody??
| |
| MSSQLServerDeveloper 2005-11-04, 11:23 am |
| Thanks - I took it a little further because I needed the results in a table -
create table ##li(
an nchar(128),
ty char(8),
priv char(9),
mln nchar(128),
pp nchar(128))
INSERT INTO ##li
EXEC xp_logininfo 'SAIC-US- WEST\CorporateITSDBA
_Admins', 'members'
select * from ##li
"Jasper Smith" wrote:
> exec xp_logininfo 'domain\group','memb
ers'
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> " MSSQLServerDeveloper
" < MSSQLServerDeveloper
@discussions.microsoft.com>
> wrote in message news:4D2CBEAB-6E96-46CE-B088- D7EBDCACAA11@microso
ft.com...
>
>
>
|
|
|
|
|