SQL Guide : Using SQL for database administration : Managing user privileges and roles : Deleting users
  
Deleting users
DROP USER username;
Only an administrator has the privilege to execute this statement. The following example deletes the user named CALVIN.
DROP USER CALVIN;
See also
Managing user privileges and roles