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
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:
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.
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
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
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
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,
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