Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: public synonym

Re: public synonym

From: David Pattinson <david_at_addease.com.au>
Date: Tue, 18 May 1999 09:34:05 +1000
Message-ID: <3740A76D.F1087C4@addease.com.au>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US