In <35803853.CA84914D_at_image.dk> Gorm Larsen (1relax_at_image.dk) wrote:
> Vladimir Bednikov skrev:
> > I have a view of two tables. This view has a public synonym created by
> > the owner of the view. Both as the
> > user and DBA the view can be seen. Whenever another user attempts to
> > access the view the error "Object
> > does not exist" is reported, yet looking through all_objects and
> > all_views any user can see the view and
> > synonym.
>
> Being quite new to Oracle this could be wrong, but did you remember to
> grant select to public on the tables ?
>
You don't have to grant select on tables which are used to form view.
The only grant you need to issue to public is grant on your view.
Regards, Sergey.
Received on Tue Jun 16 1998 - 11:01:49 CDT
