Re: Default schema...

From: <dlm_at_hermes.dlogics.com>
Date: 20 Mar 93 19:44:24 CST
Message-ID: <1993Mar20.194425.1351_at_hermes.dlogics.com>


In article <1993Mar17.233235.21293_at_lgc.com>, jason_at_lgc.com (Jason Pritchard) writes:
>
> Does anyone know of a way to set the default schema to a different
> schema (assuming that you have correct privileges, etc.)?
>
> In other words, I connect as "a" but want to have "b" as the default
> schema.

Create synonyms in your schema which are defined as the corresponding objects in the other schema.

        CREATE SYSNONYM blah FOR other.blah;

--
Dave Mausner, Senior Consultant / Datalogics Inc / Chicago IL / 312-266-4450
dlm_at_dlogics.com                                 Motto: Just show me the code
Received on Sun Mar 21 1993 - 02:44:24 CET

Original text of this message