Re: How to best schedule jobs in another schema?
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 15 Feb 2010 17:08:30 -0600 (CST)
This seems like the best answer. Using either this or the local procedure
seem to be security risks, which is ironic in this case, as it would appear
that security is the reason that the Scheduler job creation works the way it
does.
Thanks Vlado and Taral!
Rich
> http://www.pythian.com/news/652/using-dbms_sys_sql-to-execute-statements-as-another-user/
>
> On Fri, Feb 12, 2010 at 8:38 AM, Barun, Vlado <Vlado.Barun@xxxxxxx> wrote:
>
>> I have not tried this for creating new jobs, but what about using
>> dbms_sys_sql?
>>
>>
>> Vlado Barun, M.Sc., OCE, OCP, MCP
--
//www.freelists.org/webpage/oracle-l
Other related posts:
