Re: Object does not exists problem

From: Gorm Larsen <1relax_at_image.dk>
Date: Thu, 11 Jun 1998 22:04:35 +0200
Message-ID: <35803853.CA84914D@image.dk>

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 ?

--
Gorm Larsen
1relax_at_image.dk og gla_at_syspart.dk Received on Thu Jun 11 1998 - 15:04:35 CDT