Syntax
If the service account is linked to a user, it can not be dropped. In order to drop a service account linked to a user, the link must be reset
alter user foo set service_account=new_service_account|DEFAULT or the user dropped.