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".
2017-08-25, 1404👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...