Grant permission to KILL connections (sessions) for certain databases only?
4
votes
3
answers
17082
views
For a SQL Server on a VM/physical box (not Azure SQL database!)
Is this possible to grant KILL permission, but in a way that grantee can kill connections only for certain databases ?
I would not want to grant this user ability to kill any connection, but just 1 database
Thanks!!
Asked by Aleksey Vitsko
(6195 rep)
Sep 13, 2017, 09:07 AM
Last activity: Oct 5, 2019, 09:52 PM
Last activity: Oct 5, 2019, 09:52 PM