Re: Public Procedures???

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 26 Sep 1999 21:30:39 -0400
Message-ID: <r8juNxQgpttx4=rnO25d92PLvypN@4ax.com>

A copy of this was sent to Chris Forlano <cforlano_at_nortelnetworks.com> (if that email address didn't require changing) On Sun, 26 Sep 1999 22:58:02 +0100, you wrote:

>How do I create a procedure that can be executed by any user?
>

grant execute on PROCEDURE_NAME to public;

>Thanks,
>
>Chris

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Sep 26 1999 - 20:30:39 CDT