Re: Object does not exists problem

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Tue, 16 Jun 1998 16:43:41 +0100
Message-ID: <6m63qn$eem$1@schbbs.mot.com>

Although you have access to the view do you have access to the individual tables being referenced within it? Find out what the table names are and ensure you have the required read access to them.

Also, any other objects used in the SQl of the view like sequences...

HTH --
Alan D. Mills

To email remove NOSPAM from address.
Vladimir Bednikov wrote in message
<357F2157.7495958D_at_dsto.defence.gov.au>...
>I am currently trying to solve this problem, any help would be
>appreciated.
>
>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.
>
>Does anyone know the problems cause or solution?
>
>
Received on Tue Jun 16 1998 - 10:43:41 CDT