Re: Public synonym problem

In <DHouE2.E7r_at_dorsai.org>, vkwan_at_news.dorsai.org (Vito Kwan) writes:
>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

Creating a public synonym for a table does not give users access to that table. It only lets them refer to a table using a synonym instead of the actual table name. You (user scott in this case) needs to grant your other users access to table scott.emp before they will be able to use this table.

M.Landa Received on Wed Nov 08 1995 - 00:00:00 CET