Re: server roles

From: Kimberly L. Tripp (Kimberly_PleaseReplyOnTheNewsGroups@nospam.sqlskills.com)
Date: 04/11/03 

From: "Kimberly L. Tripp" <Kimberly_PleaseReplyOnTheNewsGroups@nospam.sqlskills.com <Kimberly_PleaseReplyOnTheNewsGroups@nospam.sqlskills.com>
Date: Fri, 11 Apr 2003 14:06:08 -0700

Hey there Joachim - Nope - there's no "hierarchy" per se. The only group
that encompasses ALL groups is SysAdmin. As for ITW...yes, I agree with you
here...creating indexes is NOT really a sysadmin job BUT they've limited
profiler to be sysadmin due to the overhead as well as the level of
resources it accesses. You might not totally agree but unfortunately that's
the current requirement.

I looked in the KB to see if there was anything that I missed but the only
thing I found was: Q310175 - BUG: BOL Incorrectly States That Users Do Not
Need to Be Sysadmin to Use Profiler or SQL Profiler SPs.

I hope this helps...
kt

**** Please reply only on the newsgroups! Include dml/ddl, when possible.
Thanks ****
Kimberly L. Tripp
President, SYSolutions, Inc. www.SQLSkills.com
Principal Mentor, Solid Quality Learning www.SolidQualityLearning.com

,
"Joachim Hofmann" <joachim.hof@gmx.de> wrote in message
news:3E968DA8.29AB3115@gmx.de...
> Hello,
>
> 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
> one group, it has got implicitically also the permissions of a lower group
? I.e. a member of "serveradmin" has also the permissions of the group
> "securityadmin"?
> 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". But creating and
> index is IMHO *not* the maximum level of managing a database, or is it (?)
>
> Thank You
>
> Joachim
>
>

Relevant Pages

  • Re: SQL Profiler wont allow a developer to login
    ... I can login to Profiler he get an Invalid ... whether they are sysadmin. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: AdventureWorks scripts
    ... Regarding permissions you should verify that the user you're looking into has at least CREATE DATABASE permissions, but for you're purposes you'll probably have CONTROL SERVER which includes the other. ... If you are not a member of SysAdmin, check your specific permissions at the Server level to see if you have CREATE DATABASE, which you can do from the Securables page of the Property dialog by clicking Search and following the path from there. ... If you're working with SQL Server 2008, you would have configured this during installation of SQL Server and it is likely the same user as the person who did the installation. ...
    (microsoft.public.sqlserver.programming)
  • Re: Profiler: Seven words you can never use in a script?
    ... you have to be a sysadmin to define and execute a trace in SQL Server ... this is a security measure within Profiler. ... -- 'encryption' was found in the text of this event. ...
    (microsoft.public.sqlserver.tools)
  • Re: DTS in ASP
    ... Giving IIS_WPG permissions to the database (db_owner and sysadmin) ... (IWAM_MACHINE is member of this group) ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server Performance varies by NT account
    ... > The slow account is a member of sysadmin. ... Use Profiler to actually look at what commands that are submitted. ...
    (microsoft.public.sqlserver.server)