Make the view in temp (temporary view). Views and Triggers in temp can run against anything and are always trusted.