Re: Has anyone heard of a 64KB limit for ONE stored proc in Oracle 81 7

From: Per-Arne Hellarvik <phellarv_at_genuity.no>
Date: Thu, 27 Jun 2002 16:46:44 +0200
Message-ID: <aff8hi$g89$2@news1.c.no1.asap-asp.net>

On Thu, 27 Jun 2002 16:19:17 +0200, Norman Dunbar wrote:

>
> PS. I found out that in order for users to create the docs and run them,
> they *must have* CREATE_ANY_PROCEDURE and EXECUTE_ANY_PROCEDURE privs.
> Oh dear !
>

Uh....I believe a GRANT EXECUTE ON <PROC> should do the trick without granting execute all....

> I've already demonstrated how to trash a database with these privs alone
> - they didn't like me much after that !!!
>
> ------------------------------------- Norman Dunbar Database/Unix
> administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
Received on Thu Jun 27 2002 - 09:46:44 CDT