Re: Can't edit logins or server roles

From: rmunson8 (rmunson8_at_discussions.microsoft.com)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 12:07:13 -0700

For some reason I don't have the sp_logininfo proc on my machine

"Sue Hoegemeier" wrote:

> You need to check the BUILTIN\Administrators group to see if there
> permissions have change.
> You need to check to see of you fall under another group - windows or
> sql server - that could be affecting your permissions.
> To get a list of all windows accounts that are members of the
> BUILTIN\Administrators group on the server, you can use:
> EXEC xp_logininfo 'BUILTIN\Administrators', 'MEMBERS'
>
> -Sue
>
> On Mon, 13 Sep 2004 09:23:41 -0700, "rmunson8"
> <rmunson8@discussions.microsoft.com> wrote:
>
> >sp_helplogins gives me a list of logins, but doesn't tell me if which local
> >NT admins are a part of the BUILTIN\Administrators.
> >
> >"Kevin McDonnell [MSFT]" wrote:
> >
> >> As Sue said, by default this is true. Local NT Administrators are members
> >> of the BUILTIN\Admininistrators are members of the sysadmin group.
> >>
> >> Run sp_helplogins to verify what logins exists.
> >>
> >> Thanks,
> >>
> >> Kevin McDonnell
> >> Microsoft Corporation
> >>
> >> This posting is provided AS IS with no warranties, and confers no rights.
> >>
> >>
> >>
> >>
>
>

Relevant Pages

  • Re: Cant edit logins or server roles
    ... "Sue Hoegemeier" wrote: ... > sql server - that could be affecting your permissions. ... > To get a list of all windows accounts that are members of the ...
    (microsoft.public.sqlserver.security)
  • Re: Cant edit logins or server roles
    ... sql server - that could be affecting your permissions. ... To get a list of all windows accounts that are members of the ...
    (microsoft.public.sqlserver.security)
  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • Re: Deny access to all users (including Administrator and DomainAd
    ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
    (microsoft.public.sqlserver.security)