Re: public synonym

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sun, 26 Jul 1998 17:39:35 GMT
Message-ID: <6pfpl3$ank@bgtnsc03.worldnet.att.net>

You need to also have access to the table. You may need to issue a grant command like the following:

grant select on table1 to user2;

You must issue the grant when logged in as the table owner, in this case user1.

On 24 Jul 1998 01:56:50 GMT, dshi_at_magpage.com (David Shi) wrote:

>I created a public synonym but still don't see it as another user, why?
>
>I think what I did is:
>
> create public synonym table1 for table1; as user1
>
>When I log in as user2, I can't do "desc table1".
Received on Sun Jul 26 1998 - 12:39:35 CDT