Granting packages [message #938] |
Thu, 14 March 2002 08:24 |
Eduardo
Messages: 12 Registered: October 2001
|
Junior Member |
|
|
Can be garnted execute on a procedure that is part of a package??
Thanks!
|
|
|
Re: Granting packages [message #941 is a reply to message #938] |
Thu, 14 March 2002 10:33 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
no, you cant grant privilege on packaged procedure. what you can do is wrap that procedure with stand alone procedure and grant execute privilege on that stand alone procedure.
Ex:
lets say, you have 2 procedures in package. you want to grant execute to user1 on only one procedure ,then follow these steps.
pkg1
procedure proc1
procedure proc2
create stand-alone procedure to call proc1
create or replace procedure proc1 is
begin
pkg1.proc1;
end;
/
sql>grant execute on proc1 to user1;
now, user1 can execute only pkg1.proc1.
HTH
Suresh
|
|
|