RE: Execute priv to an isolated procedure inside a package

2001-03-27 Thread Jamadagni, Rajendra
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

RE: Execute priv to an isolated procedure inside a package

2001-03-27 Thread Hillman, Alex
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:

RE: Execute priv to an isolated procedure inside a package

2001-03-27 Thread MacGregor, Ian A.
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.

RE: Execute priv to an isolated procedure inside a package

2001-03-27 Thread Paul Baumgartel
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

RE: Execute priv to an isolated procedure inside a package

2001-03-27 Thread Abdul Aleem
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

RE: Execute priv to an isolated procedure inside a package

2001-03-27 Thread Jamadagni, Rajendra
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

RE: Execute priv to an isolated procedure inside a package

2001-03-27 Thread Dasko, Dan
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,

RE: Execute priv to an isolated procedure inside a package

2001-03-27 Thread Jack C. Applewhite
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