Mega Code Archive

 

Categories / MSSQL Tutorial / User Role

 

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