Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restricting procedure calls to a package

Re: Restricting procedure calls to a package

From: David Sharples <davidsharples_at_gmail.com>
Date: Wed, 5 Apr 2006 23:35:28 +0100
Message-ID: <be592d550604051535p16698fd8i1b48fe7174ce71ca@mail.gmail.com>


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-l
Received on Wed Apr 05 2006 - 17:35:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US