Re: Question on Grant Execute

From: Sally Madeira <sallym1_at_home.com>
Date: Mon, 23 Apr 2001 17:10:17 GMT
Message-ID: <ZlZE6.17988$Ce4.1627068@news1.rdc1.ct.home.com>

Martin,

Thanks for the feed back. I have never had the opportunity to use cller feedback thus I am a little new to that terminology. What is the syntax for caller indentification and do I have to use it with in each procedure with the package owned by procown or just the calling procedure.

thanks

"Martin Haltmayer" <Martin.Haltmayer_at_0800-einwahl.de> wrote in message news:3AE21256.3B2C642F_at_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 Mon Apr 23 2001 - 12:10:17 CDT