Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201

    Unanswered: Allow user to Kill Sesions

    I have a user who is Business owner of a database that is transactional.

    At times some of here staff will be the leadblocker.

    She has requested that she be allowed the abiity to KILL spids that are blocking her remaining users. All have blessed this process and I havve been tasked to create a way for this to be accomplished.

    Is this as simple as allowing this user a permission or is it more in depth.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Only a system administrator can kill processes.

    My suggestion would be to create a login specifically for this purpose (kills by a business owner), and write a small application that actually uses that login to do the kill.

    You have a minor problem working out how to authenticate the user, but I wouldn't think that would be too complicated, especially if you use Windows Authentication.

    -PatP

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    My suggestion would be to find out why the processess are being blocked and actually fix the problem....but that's just me.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I have to agree with Pat and Blindman here on the right way to approach this. You may end up with this user killing backup jobs, data updates, and other stuff that can be a real pain to both troubleshoot, and fix.

    That said, you can accomplish this by adding the user to the processadmin server role. Good luck.

  5. #5
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201
    Thank you all for your suggestions.

    I will try to implement. I would attempt to fix the problem however I am just keeping the lights on, on this server. No longer in my sphere of control.

  6. #6
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    Quote Originally Posted by rbackmann
    Thank you all for your suggestions.

    I will try to implement. I would attempt to fix the problem however I am just keeping the lights on, on this server. No longer in my sphere of control.
    Pehaps, given the requirements of this task, that is for the best from your point of view
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •