The suggestion works, only one concern I have is that we need to at minimum create a user on the database even though it does not have rights on the databases.

Example

User has select rights to the one view on database A. The view points to database B where the user has been created but without any rights. Is there no way of keeping the user off database B completely?