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;
GO
"I always wanted to be somebody, but I should have been more specific" ~ Lily Tomlin
CREATE LOGIN
ALTER LOGIN
Equivalent Oracle commands: DROP USER