By Using a Session Variable, you can work on this.
In order to do this have synoniams in a sysadmin schema, such that based on user you refer to schema where they actualy belongs to. we do practice this while we migrate between enviornments. While development, our RPD connects to Dev Box, in SIT/UAT, it does connects to respective schemas and in production, it points to production box. Try creting synoniams and table definations with help of DBA and set this up.