Remove a SQL Server login account (User).
Syntax DROP LOGIN login_name Options login_name The login to be dropped.
This command will fail if the user is currently logged in or if the login owns any securable, server-level object, or SQL Server Agent job.
DROP LOGIN Billg;
"I always wanted to be somebody, but I should have been more specific" - Lily Tomlin
Equivalent Oracle commands: