Thanks, Dante!

Thanks, Dante, I am sorry my original question was a little confusing. here is my SQL:

SQL> run
  1 select *
  2 from all_objects
  3 where
  4 object_name = 'V_CONTACT'
  5 or
  6 object_name = 'V_PERSON'
  7* order by object_name

OWNER OBJECT_NAME OBJECT_TYPE CREATED LAST_DDL_ STATUS -------- ------------ ------------ --------- --------- ------- PUBLIC V_CONTACT SYNONYM 29-JUL-98 29-JUL-98 VALID

PUBLIC   V_PERSON      SYNONYM      29-JUL-98 29-JUL-98  VALID
XOXOXOX  V_PERSON      VIEW         29-JUL-98 28-NOV-98  VALID

Since the object that the synonym points to (v_contact, a view) is not accessible by me, when I desc, I got the following message:

SQL> desc v_contact;
Object does not exist.

So, my problem is, I need the DBA to grant the privilege to access the VIEW object (v_contact). Right?

Thanks again, Dante!
Y.Su

In article <7hpomb$s2f$1_at_nnrp1.deja.com>,   Dante <dnotari_at_my-dejanews.com> wrote:
> I have to confess that I am not absolute sure
> what you mean by "view" a synonym.
>
> A synonym is a pointer to a database object.
>
> You don't grant privileges on a synonym, you
> do it on an object.
>
> In your case the synonym v_person is pointing to
> a table/view v_person.
>
> If you describe or select from v_person the
> server tries to resolve v_person in the
> connected users namespace, if it can't find
> an object with that name it looks for a synonym
> in the PUBLIC namespace. To access that object
> it must a) exist and b) the connected user
> must have the privilges for the operation.
>
> As you can create a synonym to an non existing
> object it is possible that a view/table v_contact
> does not exist.
>
> Select from ALL_OBJECTS and see how many V_CONTACTs
> exist. With the OBJECT_TYPE you will see what sort
> of object it is, with OWNER you will see in whose
> namespace the object was created.
>
> Hope it helps
> Regards
> Dante
>
> In article <7hpf06$kns$1_at_nnrp1.deja.com>,
> 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.---
> >
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 17 1999 - 16:36:48 CDT