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, 4332🔥, 0💬
Popular Posts:
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...