User Role MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. User Role
  4. Denying SQL Server Access to a Windows User or Group
USE [master]
GO
DENY CONNECT SQL TO [YourID\TestUser]
GO
--To allow access again, you can use GRANT:
USE [master]
GO
GRANT CONNECT SQL TO [YourID\TestUser]
GO