Re: Trouble granting rights to view that call functions in packages in 7.3.3

From: Peter Schneider <peter.schneider_at_okay.net>
Date: Tue, 28 Apr 1998 19:01:14 GMT
Message-ID: <3546260c.6917783@news.okay.net>

On Tue, 28 Apr 1998 08:17:17 -0700, Clete Rodriguez <crodriguez_at_westernasset.com> wrote:

>Our dba changed the compatibility mode on our 7.3.3 server from 7.2 to
>7.3 and we're having trouble granting select rights to views that make
>calls to functions in stored procedures.
>
>Whenever we try to execute the grant statement we lose our connection.
>The error number is 3114, "not connected to Oracle". We verified that
>the user granting rights to the view has WITH GRANT OPTION privileges
>for all dependent objects.
>

Hi Clete,

AFAIK this is a bug in 7.3.3.0.x which is fixed in 7.3.4. If you call Oracle support they should be able to tell you which patchset you need. Maybe there is a fix already in one of the 7.3.3 patches, but I'm not sure about this.

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Tue Apr 28 1998 - 14:01:14 CDT