Re: Thanks, Dante!

First make sure that the view really exist. Connect as the owner of the view and
  describe your view.

Then you can grant selective privileges   on the view to

1. a specific user or
2. to public

eg.
  GRANT SELECT ON V_CONTACT TO <username>; or GRANT SELECT ON V_CONTACT TO PUBLIC;

make sure that you are connected as the owner  of the v_contact view.

You can connect as SYSTEM or SYS and
grant qualified:
  GRANT SELECT ON <view owner>.V_CONTACT TO .... ;

Hope it helps
Regards
Dante

In article <7hq25g$312$1_at_nnrp1.deja.com>,   ypsu_at_my-dejanews.com wrote:
> 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.---
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 18 1999 - 03:09:35 CDT