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, 2760🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...