What is the SQL to delete a SQL User from a database?
What is the SQL to delete a SQL User fro开发者_JS百科m a database?
DROP USER [UserName]
You can prefix this with an existence check if required.
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'UserName')
There are some requirements to be met before dropping Users (e.g. they can't own any objects). Full Details here.
精彩评论