Re: Package/Function Security

From: Peter Rak <po080016_at_pop.ke.sanet.sk>
Date: 1996/06/21
Message-ID: <31CAB9E3.1DF_at_pop.ke.sanet.sk>#1/1

Ronald J. Zapar wrote:
>
> How do you grant execute to users who want to use a package/function in an SQL
> statement without granting them EXECUTE ANY PACKAGE or EXECUTE on that
> particular package/function? Using a role only allows the user to execute the
> package in a view created by the package owner.
>
> Send any replies to rzapar_at_qci.com

Hi,
try following:

sqlplus user1/user1
create package 'package'

...
...
...

/
grant execute on 'package' to user2;
connect user2/user2
create synonym 'package' for user1.'package'; execute 'package.procedure';

                Peter. Received on Fri Jun 21 1996 - 00:00:00 CEST