Sample Header Ad - 728x90

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