Permissions To Kill Any Session On Server

• ajay.g

  Ten Centuries

  Points: 1117

  More actions

  February 25, 2012 at 6:01 am

  #256427

  Hi,

  This is Ajay Kumar. G. We had requirement that User should be able to View the processes which are running on the Server. So we've given "View Server State" to him and he was able to see all the processes on the server at any time (previously, he had only DB_Owner role for all the DBs).

  But now User should be able to Kill the session which causes the issues. With "View Server State" role, he can't Kill the session, just View Only. Please let me know, which role or permission I need to provide him to Kill any Session which is running on the Server. I've tried to provide "Processadmin" and other Server roles, but he wasn't able to kill any Session.

  One thing, I shouldn't give Sysadmin role to him (to Kill the Session), because he was a normal User. Does SQL Server has any specific role for Killing the sessions? Please help me... it is an emergency....

  Note : Version is SQL Server 2008 R2

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 25, 2012 at 7:37 am

  #1451694

  Asked and answered: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=171810

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass