Re: public synonym

create public synonym table1 for user1.table1;

and you must grant appropriate privilege to user2.

>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 Fri Jul 24 1998 - 19:13:37 CDT