Re: Confusion on synonym

On 12 Oct 1998 00:04:33 GMT, suisum_at_freenet.edmonton.ab.ca () wrote:

>Can anyone explain how to get benefit from using synonym?

Other users can have access to your table without using your name as a prefix: select * from emp (in stead of select * from scott.emp).

>How it works PUBLIC and PRIVATE?

If you create a public synonym, it can be used by everyone (but they still have to have table rights before they can use it effectively). If you use a private synonym, you assign it to just one person.

>How to manage them effectively?

Depends on the situation. Maybe it's a good idea to create public synonyms for generic tables and create public synonyms for specific groups of users.

• Martin Jesterhoudt
• martinj(replace this by @)xs4all.nl

  ---