Re: DBA Permissions

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 05/08/03 

Date: Thu, 8 May 2003 15:28:01 -0400

You can shut down SQL Server using the T-SQL command SHUTDOWN but you cannot restart it, since SQL Server is not up and it needs to be up in order to determine that you are part of the sysadmin role. Starting and stopping services on a box is an administrator's job. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada   tom@cips.ca
www.pinnaclepublishing.com/sql
"George" <gfentres@hotmail.com> wrote in message news:061d01c31596$50657550$2f01280a@phx.gbl...
Can't a SQL Server user with sysadmin priviledges be able 
to do that ?
>-----Original Message-----
>If you're not in an Active Directory, then the DBA should 
also have the authority to stop and start SQL Server and 
related processes.  With AD, you can create a Group Policy 
Object to narrow down the authority to just those 
processes.
>
>-- 
>Tom
>
>----------------------------------------------------------
-----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada   tom@cips.ca
>www.pinnaclepublishing.com/sql
>
>
>"George" <gfentres@hotmail.com> wrote in message 
news:05a701c31594$b3c26330$3301280a@phx.gbl...
>Is there any other reason why a DBA should be in 
>Administrators group of the local SQL Server computer 
than 
>Installing the software and related patches and SP's ?.
>
>Is there a documentation on this ?
>
>Thanks.
>

Relevant Pages
Quantcast