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>
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 codeReceived on Sun Mar 21 1993 - 02:44:24 CET