Collections:
"ALTER LOGIN" - Disabling a Login Name in SQL Server
How To Disable a Login Name in SQL Server?
✍: FYIcenter.com
If you want temporarily disable a login name, you can use the "ALTER LOGIN" statement with a DISABLE keyword. If you want to enable it later on, you can use the ENABLE keyword. The tutorial exercise below shows how to disable and enable login name "Dba_Login":
-- Login with "sa" -- Disable a login ALTER LOGIN Fyi_Login DISABLE; -- View login status SELECT name, type, type_desc, is_disabled FROM sys.server_principals WHERE type = 'S'; GO name type type_desc is_disabled ----------- ---- ---------- ----------- sa S SQL_LOGIN 0 FYI_DBA S SQL_LOGIN 0 Dba_Login S SQL_LOGIN 1
Now try to login with the disabled login name:
C:\>SQLCMD -S LOCALHOST\SQLEXPRESS -U Dba_Login -P IYF Msg 18470, Level 14, State 1, Server LOCALHOST\SQLEXPRESS Login failed for user 'Dba_Login'. Reason: The account is disabled. C:\>
Run the statements below to enable login name "Dba_Login":
-- Login with "sa" -- Enable a login ALTER LOGIN Fyi_Login ENABLE;
⇒ "DROP LOGIN" - Deleting a Login Name in SQL Server
⇐ "ALTER LOGIN" - Changing a Login Name in SQL Server
2016-10-19, 3087🔥, 0💬
Popular Posts:
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...