Re: How to best schedule jobs in another schema?

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Mon, 15 Feb 2010 17:08:30 -0600 (CST)
Message-ID: <b3e0cda8dcad4cb9e8ad2bd3329b0354.squirrel_at_society.servebeer.com>



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_at_jtv.com> wrote:
>
>> I have not tried this for creating new jobs, but what about using
>> dbms_sys_sql?
>>
>>
>> Vlado Barun, M.Sc., OCE, OCP, MCP

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 15 2010 - 17:08:30 CST

Original text of this message