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 object exists!

Re: ORA-00980, but object exists!

From: <epokopac_at_excite.com>
Date: Thu, 25 Oct 2007 06:56:21 -0700
Message-ID: <1193320581.968483.42100@d55g2000hsg.googlegroups.com> 





Just a guess:



This could 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).



Make sure the owner of the program unit has directly-assigned
privileges (NOT via a role) on the synonym's target object.
Received on Thu Oct 25 2007 - 08:56:21 CDT












Original text of this message













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