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." <[EMAIL PROTECTED]> 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@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
