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".
Â
2022-01-24, 2064👍, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...