Re: Help: A difficult requests

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 14 Nov 2005 07:29:27 +0100
Message-ID: <rjbgn1h3qult7bjbifhp9bvpv9tup0si1q@4ax.com>

On Mon, 14 Nov 2005 00:59:28 GMT, "joe bayerii" <joebayerii(delete)@hotmail.com> wrote:

>My question is, can we somehow control Oracle, by profile or something, let
>schema go directly to synonym, not table? Is that possible?

There are several ways to end up in a mess, but if there is a synonym, the synonym will always take precedence, and this can NOT be changed (other than by dropping the synonym)

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Nov 14 2005 - 00:29:27 CST