Collections:
"ALTER USER" - Changing the Name of a Database User in SQL Server
How To Change the Name of a Database User in SQL Server?
✍: FYIcenter.com
If you want to change the name of an existing database user, you can use the "ALTER USER" statement as shown in the tutorial exercise below:
-- Login with "sa" USE FyiCenterData; GO ALTER USER Fyi_User WITH NAME = Dba_User; GO -- List all user names SELECT name, sid, type, type_desc FROM sys.database_principals WHERE type = 'S'; GO name sid type type_desc -------------------- ------------------------ ---- --------- dbo 0x01 S SQL_USER guest 0x00 S SQL_USER INFORMATION_SCHEMA NULL S SQL_USER sys NULL S SQL_USER Dba_User 0x5EB8701EAEBAA74F86F... S SQL_USER
The of the last user changed from "Fyi_User" to "Dba_User".
⇒ "DROP USER" - Deleting a Database User in SQL Server
⇐ Verifying a User Name with SQLCMD Tool in SQL Server
2022-01-24, 4263🔥, 0💬
Popular Posts:
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...