"ALTER USER" - Changing the Name of a Database User in SQL Server

Q

How To Change the Name of a Database User in SQL Server?

✍: FYIcenter.com

A

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".

 

Managing Security, Login and User in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-18, 375👍, 0💬