SQL Server DBA Tutorial 57- How to Enable and Disable Login in SQL Server

*****************************************************************************************
* How to Enable and Disable Login in SQL Server *
*****************************************************************************************

We will be using two ways in SQL Server
1. Using SQL Server management studio graphic user interface GUI Version
2. Using T-SQL script

/*************T-SQL script****************/
-- Disable Login--
USE [master]
GO
DENY CONNECT SQL TO [chirags]
GO
ALTER LOGIN [chirags] DISABLE
GO

-- Enable Login --
USE [master]
GO
GRANT CONNECT SQL TO [chirags]
GO
ALTER LOGIN [chirags] ENABLE
GO
/******************************************/

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#ChiragsTutorial
#DBATutorial
#DBATutorialLearning
#DBAEducation
#DBATutorialFree
#DatabaseTutorial
#SQLServerDatabaseTutorial
#SQLServerDBATutorial
#MicrosoftSQLServerDatabaseTutorial
#ChiragsDBATutorial
#ChiragsDatabaseTutorial
#ChiragsSQLServerDatabaseTutorial
#ChiragsSQLServerDBATutorial
#ChiragsMicrosoftSQLServerDatabaseTutorial
#CreateDatabaseinSQLServer
#CreateDatabasewithT-SQL
#SQLServerVulnerabilityAssessment
#SQLServerLogin
#SQLServerLoginDisable
#SQLServerLoginEnable