RE: Execute priv to an isolated procedure inside a package
I think your idea is the only solution other than yanking out the packaged procedure and making it standalone. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! * This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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).
RE: Execute priv to an isolated procedure inside a package
You can create the wrapper procedure owned by user A. Give this user execute on the package you are wrapping and give users who need to use wrapper execute in wrapper procedure. Alex Hillman -Original Message- From: djordjej [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 8:40 PM To: Multiple recipients of list ORACLE-L Subject:Execute priv to an isolated procedure inside a package 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: Hillman, Alex 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).
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@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).
RE: Execute priv to an isolated procedure inside a package
That is correct. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 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@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: Paul Baumgartel 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).
RE: Execute priv to an isolated procedure inside a package
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@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: Abdul Aleem 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).
RE: Execute priv to an isolated procedure inside a package
Ian, You are 100% correct, but then that program unit becomes internal to the package and can only be accessed by other program units in that package. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! * This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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).
RE: Execute priv to an isolated procedure inside a package
I'm coming late to this thread, but then couldn't you set things up in an OO paradigm and have the accesssible functions(methods) check the userid and control access that way? So if the package is a ccessible by anyone, and function A is the one with no external access, build in functions B, C, D that access the functionality of function A like public methods in OO. Then include in B,C,D a check against the userid for access to function A. Maybe I'm missing something, and it does seem like a bit of work, but it makes sense to me. Dan -Original Message- Sent: Tuesday, March 27, 2001 9:22 AM To: Multiple recipients of list ORACLE-L Ian, You are 100% correct, but then that program unit becomes internal to the package and can only be accessed by other program units in that package. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! * This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan 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).
RE: Execute priv to an isolated procedure inside a package
Ian, You are 100% correct. A procedure, function, cursor, etc. not declared in the package spec, but only in the package body is considered private to the package and cannot be executed by any external call, only by calls from other procedures, functions, etc. within the package. That way you can only expose the items that you truly want to be public. IMHO, it is not a limitation at all, but a very valuable mechanism for enforcing selective security. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- MacGregor, Ian A. Sent: Tuesday, March 27, 2001 7:45 AM To: Multiple recipients of list ORACLE-L 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@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: Jack C. Applewhite 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).