Re: How to execute another users job?

Caja wrote:

> Hello,
>
> I ran into the following problem:
> I have to run a job in a certain schema. I currently do not have the
> password for that schema but I can login as user SYSTEM or even SYS as
> sysdba.
> Is there any chance to run the users job with
> exec dbms_job.run(1)
> as user SYSTEM?
>
> Thanks for help or advice.
>
> Carsten

You can do it ... but you shouldn't. Get the required password and do it the correct way. If you can not get the password then you have no business running the job.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)