"DROP USER" - Deleting a Database User in SQL Server

Q

How To Delete an Existing Database User in SQL Server?

✍: FYIcenter.com

A

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.

 

Managing Security, Login and User in SQL Server

⇒⇒SQL Server Database Tutorials

2017-08-25, 270👍, 0💬