Re: Help: A difficult requests

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:rjbgn1h3qult7bjbifhp9bvpv9tup0si1q_at_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

In support, this may help clarify. It's from the 10gR2 manual about "Managing Object Name Resolution."

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/general.htm#sthref1891

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.