Re: public synonym

From: Winnie Liu <poohland_at_hotmail.com>
Date: Thu, 23 Jul 1998 19:09:34 -0700
Message-ID: <6p8q4s$4t0@dfw-ixnews10.ix.netcom.com>

Have you grant the select/update/delete/insert privilege to user2? Even though it is a public synonym, you still have to grant the privilege to another user. But now they can use the name of the table directly instead of referring to the schema.

Winnie

David Shi wrote in message <6p8pl2$hqd$0_at_204.179.92.157>...
>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".
>
>David
Received on Thu Jul 23 1998 - 21:09:34 CDT