Home » SQL & PL/SQL » SQL & PL/SQL » Granting packages
Granting packages [message #938] Thu, 14 March 2002 08:24 Go to next message
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 Go to previous message
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
Previous Topic: Load data into a table via a stored proc.
Next Topic: RE: Keys
Goto Forum:
  


Current Time: Fri Mar 29 06:49:57 CDT 2024