One way to support multiple unassociated hosts in one database is to support multiple local acs-authentication authorities and to key the unique username/email constraint on the authority_id.
This way you could have completely seperate logins per host mapped subsite. As far as I know noone has implemented this yet.
