RE: Execute priv to an isolated procedure inside a package

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Tue, 27 Mar 2001 06:51:34 -0800
Message-ID: <F001.002D8C5D.20010327060027@fatcity.com>

Ian,

To my understanding you mean local procedure / functions, these then would not be available outside the package. And has to be defined before any local/public function/procedure that uses it. Am I right?

Aleem

-----Original Message-----
Sent: Tuesday, March 27, 2001 6:45 PM

To:     Multiple recipients of list ORACLE-L
Subject:        RE: Execute priv to an isolated procedure inside a package

I have not tested this. I believe ,with about a 60% level of confidence, you can place a function/procedure in the body of a package without placing its definition in the package's specification. If so, the function/procedure should not be available when exectute is granted on the package.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac,stanford.edu

-----Original Message-----
Sent: Monday, March 26, 2001 5:40 PM
To: Multiple recipients of list ORACLE-L

Hi friends,

One cannot grant execute privilege to a specific procedure/function inside a package, but only for all or nothing that is in that package.

Anybody has an idea how this limitation can be overcomed. One idea is to create a separate stand-alone procedure that will just be a wrapper around the packaged procedure and call it. Any other ideas.

Thanks.

Djordje

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: djordjej
INET: djordjej_at_home.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------