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 CET