Re: Public Synonyms on Tables - Good or Bad?

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.
>
Received on Tue Jan 29 2002 - 13:40:54 CST