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: Question on Grant Execute

Re: Question on Grant Execute

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sun, 22 Apr 2001 01:05:58 +0200
Message-ID: <3AE21256.3B2C642F@0800-einwahl.de> 






Try using caller identification (in Oracle 8.1.x) because if you have a
procedure procabc that is owned by procown and accesses a table proctab, it will
always access that table that is defined by name resolution of the procown. So
without caller identification you have to use dynamic sql incorporating the
calling user to access the correct table.



Martin
Received on Sat Apr 21 2001 - 18:05:58 CDT












Original text of this message













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