DROP USER

Remove a user from the current database.

Syntax
      DROP USER username

Key
   username    Name of the user to be dropped.

A user that owns securables cannot be dropped.

Examples

DROP USER JaneDoe;

"A chic type, a rough type, an odd type - but never a stereotype" - Jean-Michel Jarre

Related commands

spRemoveLogin - A stored procedure that can be used to remove SQL logins from multiple databases.
CREATE USER
ALTER USER
Equivalent Oracle command: DROP USER


 
Copyright © 1999-2024 SS64.com
Some rights reserved