Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00980, but public synonym is there (Oracle Reports) ?

Re: ORA-00980, but public synonym is there (Oracle Reports) ?

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Wed, 24 Jul 2002 14:03:52 +0400
Message-ID: <ahlu2h$ako$1@babylon.agtel.net>


This can be due to privileges inherited from roles. If you don't grant privileges directly, stored procedures will not see referenced objects (roles are disabled for them unless they are authid current_user).

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
news:ahlmo5$u5mtj$1_at_ID-152732.news.dfncis.de...

> Hello,
>
> I would like to know if there are some circumstances under which a valid
> public synonym still brings up
> ORA-00980 (in Oracle Reports).
>
> The situation is this:
> We have two main schemas, one is crowded with tables and all stored
> procedures, and one with a single but
> large table. This table has a public synonym and can be selected from in
> SQLPlus and so on.
>
> But in Oracle Reports, the synonym "cannot be resolved". All other tables
> can be selected, but the update on the
> special large table failes.
>
> Or is Reports behaving different from SQL*Plus ? One of our developers gave
> up using synonyms
> and started adding [schema.]table to the statements.
>
> Has anybody here made similar observations ?
>
> ThanX in advance.
>
> Jan
>
>
Received on Wed Jul 24 2002 - 05:03:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US