Re: new userID can do all...

From: K. Brian Kelley (nospam@warpdrivedesign.org)
Date: 02/05/03 

From: "K. Brian Kelley" <nospam@warpdrivedesign.org>
Date: Wed, 05 Feb 2003 14:14:06 -0800

"Rob" <rhchin@hotmail.com> wrote in news:09ac01c2cd60$c3fb3550
$89f82ecf@TK2MSFTNGXA01:

> No server roles have been assigned. Thanks.
>

Does he have administrative rights to the box (including being a member
of Domain Admins)? If so, is BUILTIN\Administrators still present with
sysadmin rights (read up before you consider removing it, there are some
KB articles that detail the issues)? 

-- 
K. Brian Kelley
Author of Start to Finish Guide to SQL Server Performance Monitoring
SQLServerCentral.com Columnist
http://www.truthsolutions.com/

Relevant Pages

  • server roles
    ... I am reading about the server roles, and it is said, they have a "level". ... But do they have a hirarchical level in that way, that a if a member is into ... I.e. a member of "serveradmin" has also the permissions of the group ... Furthermore, and why I am asking, is: If I start the index tuning wizard, I get the message "you need to be a member of sysadmin". ...
    (microsoft.public.sqlserver.security)
  • Re: new userID can do all...
    ... >> No server roles have been assigned. ... > Does he have administrative rights to the box (including being a member ... > Author of Start to Finish Guide to SQL Server Performance Monitoring ...
    (microsoft.public.sqlserver.security)
  • Re: Server roles
    ... BOL says "Contains a row for each member of a database role" about ... I want server roles. ... FROM sysmembers membs ...
    (microsoft.public.sqlserver.security)