Re: Public synonym problem

The answer to this problem is *security*. What you have done is created a synonym to add location transparency. The user issuing the select statement still requires access permisisons on the object to be accessed. The error message you get when the tablle or view does not exist, or if it exists but you have not been granted access, is ORA-942. Solution - As scott issue:

    grant select on emp to public; (or whoever you wish to have select access).

In article <DHouE2.E7r_at_dorsai.org>, vkwan_at_news.dorsai.org (Vito Kwan) wrote:

> Hi all,
> I created a public synonym in user system on scott.emp. The syntax
> that I used was
> create public synonym bob for scott.emp;
> However, the other users cannot select from the public synonym
> boo. The error was no table or view exists.
> Any help will be appreciated.
>
> Vito Kwan
> vkwan_at_dorsai.org
Received on Tue Nov 07 1995 - 00:00:00 CET