Re: how to group synonyms ?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 26 Nov 2003 23:54:55 -0800
Message-ID: <1069919723.866398@yasure>

Billy Verreynne wrote:

> "mcstock" <mcstockspamplug_at_spamdamenquery.com> wrote in
>
>

>>i highly recommend public synonyms for applications 

>
>
> Arrgghhh!!! No!! Never!!
>
>

>>-- coding the schema
>>name with the object creates maintenance and portability problems

>
>
> BULL!!
>
> Do *NOT* use public synonyms as a crutch like that. It is nothing but
> a quick and dirty method that lacks. Period.
>
> Take security, access control and scope into proper consideration and
> then DO IT CORRECTLY!!
>
> --
> Billy

I'm with Billy on this one. There is no valid reason I can think of for public synonyms beyond DUAL and others created by Oracle. And I'd even take issue with a few of theirs if I thought anyone would listen.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Thu Nov 27 2003 - 01:54:55 CST