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;
Â
2016-10-19, 1213👍, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...