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@xxxxxxxxxxxxxx> 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