Tom Dyess wrote:
>
> The good --
>
> Users don't have to prefix tables / views with the schema name - i.e
>
> user thor when selecting from emp has to reference the table this way with
> and without syns
>
> scott.emp (no syn)
> emp (syn)
>
> The bad --
>
> You can't have two syns with the same name, so your synonym names have to be
> unique - also when developing an application, you have to remember to
> declare your syn's when moving to a new database.
>
> Note --
>
> Syn's don't have anything to do with security, so security is not an issue -
> you still place your grants on the referenced table.
>
> Tom
> www.oraclepower.com
>
> "Gad krosner" <krosner_at_excite.com> wrote in message
> news:98dd002d.0201290556.189c5680_at_posting.google.com...
> > Hi There!
> >
> > What are the pros and cons for having (or not having) public synonyms
> > on tables? I work in a shop moving from Sybase to Oracle, and we
> > don't seem to agree on a given path. I'd like to hear some opinions,
> > or have some URLs to such discussions.
> >
> > Thanks,
> >
> > Gad.
> >
they also have an impact on performance to some (small) degree
--
==============================
Connor McDonald
http://www.oracledba.co.uk
"Some days you're the pigeon, some days you're the statue..."
Received on Tue Jan 29 2002 - 14:27:10 CST
