Re:RE: Execute priv to an isolated procedure inside a packag

From: <dgoulet_at_vicr.com>
Date: Tue, 27 Mar 2001 06:50:50 -0800
Message-ID: <F001.002D8D13.20010327062622@fatcity.com>

After having written thousands of lines of PL/SQL procedures to revamp some of our operational systems I can say with certainty that is you can create a function/procedure within a package, and not include it in the specification. Problem is that the procedure/function is totally invisible to any other function/procedure/anonymous PL/SQL block outside of the package. Therefore to the root question, "Can you grant execute on a specific function within a package?" the answer is no. You have to grant execute on the entire package, but the only way an end user can access the package is through the functions/procedures that are inside the specification.

Dick Goulet

____________________Reply Separator____________________
Author: "MacGregor; Ian A." <ian_at_SLAC.Stanford.EDU>
Date:       3/27/2001 5:45 AM

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
--------------------------------------------------------------------