Collections:
"DROP USER" - Deleting a Database User in SQL Server
How To Delete an Existing Database User in SQL Server?
✍: FYIcenter.com
If you don't want to keep a database user any more, you should delete the user by using the "DROP USER" statement. This tutorial exercise shows how to delete "Dba_User":
-- Login with "sa" USE FyiCenterData; GO DROP USER Dba_User; GO -- List all user names SELECT name, sid, type, type_desc FROM sys.database_principals WHERE type = 'S'; 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
User "Dba_User" has been deleted now.
⇒ SQL Server Database Tutorials
⇐ "ALTER USER" - Changing the Name of a Database User in SQL Server
2022-01-24, 2013🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...