Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL: DBMS_SQL Package...
Michael Rosadino wrote in message <351084C6.36AF_at_connico.net>...
stored under the SYS owner. Does anyone know of a way to store the
>procedure under a userspace while designing/debugging so that the code
>could be executed successfully from the userspace without having to port
>it to the SYS owner?
Mike,
You probably need to create a synonym for it and grant execute on it to public.
IE: Create synonym some_name for owner.procedure_name;
Grant execute on owner.procedure_name to public;
I'm not real sure of the syntax so check the manual.
Alex Received on Wed Mar 18 1998 - 00:00:00 CST