Post reply

DB_creator server role..

  • November 10, 2013 at 8:32 am

    #279011

    hi,

    i checked number of tutorials in that DB-creator server role can do create alter drop their own database .

    but this role(login) restarting the server ...why?

    i have created one login my server loginA

    i have given server role is dbcreator....

    and after i logged with this login in same computer..

    successfully logged but when i restart the server on server property it will stop and restarting the server ..

    Why the server role is dbcreator but how it is start and stopping the server.....

    Thanks

    Giri

  • November 11, 2013 at 1:53 am

    #1665385

    Impossible.

    Try this:

    CREATE LOGIN test WITH PASSWORD = 'somePassword', CHECK_POLICY = OFF

    EXEC sp_addsrvrolemember 'test','dbcreator'

    EXECUTE AS LOGIN = 'test'

    SHUTDOWN WITH NOWAIT

    REVERT

    -- User does not have permission to perform this action.

    -- Msg 0, Level 11, State 0, Line 0

    -- A severe error occurred on the current command. The results, if any, should be discarded.

    Maybe that user is a local administrator of the Windows machine and can interact with services, but that's a whole different story.

    -- Gianluca Sartori

  • November 11, 2013 at 2:06 am

    #1665389

    thansk...for yuur reply

    I logged with different user in my compputer..

    the start and stop buttons are in deactive state

  • November 11, 2013 at 2:17 am

    #1665392

    How do you stop the service with the dbcreator login?

    -- Gianluca Sartori

Viewing 4 posts - 1 through 3 (of 3 total)

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