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, 2096🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...