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, 1988🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...