Denying SQL Server Access to a Windows User or Group : LOGIN « User Role « SQL Server / T-SQL Tutorial





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










28.7.LOGIN
28.7.1.Creating a SQL Server Login
28.7.2.Viewing SQL Server Logins
28.7.3.Creating a Windows Login
28.7.4.Viewing Windows Logins
28.7.5.Altering a Windows Login
28.7.6.Dropping a Windows Login
28.7.7.Denying SQL Server Access to a Windows User or Group
28.7.8.Creates a new Windows login and then maps that login to a new database user
28.7.9.Create a proxy login from the certificate
28.7.10.Create a proxy user and grant access to the schema
28.7.11.DROP LOGIN
28.7.12.Altering a SQL Server Login
28.7.13.Dropping a SQL Login