Re: Public synonym problem

Vito Kwan (vkwan_at_news.dorsai.org) 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

Have you granted privileges on this table to PUBLIC?

--
---------------------------------------------------------------------------
Kannan 
Email: skannan_at_fs.com
Mastech Systems Corporation

The above are my own comments and opinion. They do not purport that of 
anybody else.
       ** Different is Not Better. Better is not Different. **
---------------------------------------------------------------------------