Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: public synonym
Yes, you need to grant rights to the object that the synonym represents.
Regards, David.
ypsu_at_my-dejanews.com wrote:
> Hi, can any of you Oracle experts out there help me out?
>
> I can not view a public synonym, v_contact. But I am able to view
> another public synonym, v_person.
> I noticed that v_person is of both synonym-type and view-type, while
> v_contact is of only synonym-type. Do I really need the view privilege
> to the VIEW object in order to view the SYNONYM?
>
> Thanks a lot!
>
> Y.Su
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Mon May 17 1999 - 18:34:05 CDT