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.

Example

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 SS64.com 1999-2014
Some rights reserved