| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Execute priv to an isolated procedure inside a package
That is correct.
Paul Baumgartel
InstiPro, Inc.
paul.baumgartel_at_instipro.com
212 813-0829 x103 (office)
917 549-4717 (mobile)
-----Original Message-----
Sent: Tuesday, March 27, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L
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).
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).
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). Received on Tue Mar 27 2001 - 08:47:13 CST
 |
 |