Reference and syntax for the DROP LOGIN command.
DROP LOGIN [ IF EXISTS ] <login_name>;
alter user foo set login="new-login@acme.com"|DEFAULT
<login_name>
DROP LOGIN "alexs@acme.com";