What schema is a view bound to, when an environment has multiple available?
I'm in a somewhat unusual situation: A vendor solution includes a server where different versions and environments exist, simply by existing in different schemas all on a single server. So for example, where normally you'd have environments on separate servers entirely, the setup includes one server with a DEVELOPMENT, STAGING, TRAINING, REPORTING, and UTILITIES schema, each of them an image of the an application database, each with it's own unique intended purpose. The REPORTING schema is the one most used on a day to day basis, and to keep all the versions read only, people who want to write their