Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restricting procedure calls to a package
if all there code is all self evneloped inone package then make everything
private apart from some functions which you can delcare in the spec which
the users can access
On 05/04/06, John P Weatherman <asahoshi_at_infionline.net> wrote:
>
> All,
>
> I may well have been reading the Wrong FM, but I haven't seen this
> explicitly ruled out anywhere either. Is it possible to grant execute
> on only selected procedures within a package or is it an all or nothing
> deal. My developers have managed to code functional units so that all
> the select/insert/update/delete code is in the same package and they
> won't break it out...but the end users who can perform these functions
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 05 2006 - 17:35:28 CDT