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, 2987🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...