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: PL/SQL-Problem with access to table of another user

Re: PL/SQL-Problem with access to table of another user

From: Nicolas Stern <spip46_at_hotmail.com>
Date: Fri, 16 Nov 2001 17:16:54 +0100
Message-ID: <3bf53bf7$1@news.psi.ch> 





Hi Ralf



I'm not sure this is the cause of the Problem, but did you check the way you
grant the access to the table: procedure access objects in the context of
the owner of  the procedure, not in the context of the caller. Procedure
owner must have access rights granted directly, not via a role.



regards

--
Nicolas Stern


Received on Fri Nov 16 2001 - 10:16:54 CST












Original text of this message













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