User member of Public Server Role - Start\Stop SQL Service

  • Here is my question.. how is this possible?

    Version: SQL Server 2005 Dev Edition on Win XP

    Steps:

    1. Created a login XYZ (user is just member of public role)

    2. Logged into SQL Server using SSMS with XYZ user credentials

    3. Right click on the server, then Stop --> Successfully stopped SQL server service

    4. Right click on server, then start --> Successfully started SQL Server service

    How a user member of public server role is able to start or stop the SQL server ????

    Thanks in advance,

    NKR

  • Start/Stop a Service is an operating system function. For SSMS, that means it actually performs it under the context of the user who start SSMS. Unless you used runas, that was you because it's not issuing a SQL command through the SQL Server, but rather making a .NET API call to start and stop the service. This is one of the few cases that the operation that is performed doesn't necessarily match how you connected to the SQL Server.

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply