Re: server roles
From: Kimberly L. Tripp (Kimberly_PleaseReplyOnTheNewsGroups@nospam.sqlskills.com)
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...
**** Please reply only on the newsgroups! Include dml/ddl, when possible.
Kimberly L. Tripp
President, SYSolutions, Inc. www.SQLSkills.com
Principal Mentor, Solid Quality Learning www.SolidQualityLearning.com
"Joachim Hofmann" <email@example.com> wrote in message
> 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
> 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