Re: To deteremine NT logins + Sql Logins with sa + dbo + prviliges

From: FR (floydrev@hotmail.com)
Date: 07/01/02 

From: "FR" <floydrev@hotmail.com>
Date: Sun, 30 Jun 2002 22:44:17 -0700

SQL 7 and SQL 2K . Have both in house.
Used exec sp_helpsrvrolemember 'sysadmin' for example and found
builtin\administrators as the group .

Then ran exec xp_logininfo 'builtin\administrators' , 'members'
and found domain\domain admin group..
But cannot drill further. Id like to drill to the lowest level where i can
get all members of the domain\domain admin group too without asking the n/w
team for assistance.
Can this be done ?

Thanks

"Morris Lewis" <Morris@Holistech.com> wrote in message
news:O$Of#jLICHA.1604@tkmsftngp09...
> What version of SQL Server? It matters.
>
> Morris Lewis
> MCDBA, MCSD, MCSE+I, MCT, CTT+
> President, Holistech Inc.
>
> "FR" <floydrev@hotmail.com> wrote in message
> news:uGxR3VGICHA.2024@tkmsftngp11...
> > I have an NT login that I guess is part of some NT group thats a valid
> login
> > on SQL Server. I definitely do not see his login individually.
> > He currently has sa priviliges which could be part of
> Builtin\Administrators
> > group. But when i look under the Admin group, dont see his name but
could
> be
> > part of the Domain admin group .
> >
> > Is there a way i can drill down to the lowest level to find out each and
> > every NT member of the builtin\Administrators group or for that matther
> any
> > NT group although i may see further groups under that.
> >
> > Please advice.
> >
> >
>
>

Relevant Pages

  • Re: Keeping User From Deleting Table Records
    ... Hugo - Your comment about the user being a member of an admin group did the ... - I have created a new Windows user login in Security/Logins that is ... SQL Server to obtain default settings for the additional configuration ...
    (microsoft.public.sqlserver.security)
  • Re: To deteremine NT logins + Sql Logins with sa + dbo + prviliges
    ... Id like to drill to the lowest level where i can> get all members of the domain\domain admin group too without asking the n/w> team for assistance. ... >>> I have an NT login that I guess is part of some NT group thats a valid ...
    (microsoft.public.sqlserver.security)
  • Re: To deteremine NT logins + Sql Logins with sa + dbo + prviliges
    ... What version of SQL Server? ... > I have an NT login that I guess is part of some NT group thats a valid ... But when i look under the Admin group, dont see his name but could ...
    (microsoft.public.sqlserver.security)
  • To deteremine NT logins + Sql Logins with sa + dbo + prviliges
    ... I have an NT login that I guess is part of some NT group thats a valid login ... on SQL Server. ... But when i look under the Admin group, dont see his name but could be ...
    (microsoft.public.sqlserver.security)
  • Add domain group to local group for remote VPN users
    ... for a solution especially for remote users with a 3rd party VPN software ... member of the domain admin group. ... Second option for computers within the local network and LAN connection we ... I try to explain how the remote users login and how they access network ...
    (microsoft.public.windows.group_policy)