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.

You need to grant select access on scott.emp to the users who want to access that table. The public synonym creates a pointer to the table but if it points to something you can't access, then you still can't access it via the pointer.

It's like symbolic links in UNIX.

Hope this helps,

John

--
 
John Blackburn                           Phone: +61 7 32534634
jb2_at_qdot.qld.gov.au                      Fax:   +61 7 38541194

"Please enclose a stamped, self-addressed ethernet packet with
 all correspondence..."

#include <std_disclaimer.h>