Re: How to execute another users job?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 13 Apr 2005 21:39:24 +0200
Message-ID: <425d7545$0$10371$636a15ce@news.free.fr>

"JSW" <kokisarmiento_at_yahoo.com> a écrit dans le message de news:1113417932.947294.251240_at_z14g2000cwz.googlegroups.com...
| You can not run jobs that are not in your own job queue. You should try
| to get the password, but if you can not, then connect as SYSTEM and
| reset the password (set new password for userX, run the job as userX,
| restore userX old password). No need to know userX password.
|
| connect system/password
|
| SELECT username, password FROM dba_users WHERE username='X';
| USERNAME PASSWORD
| ------------------------------ ------------------------------
| X 9F56C14116139736
|
| ALTER USER userX IDENTIFIED BY new_password;
|
| >From a new SQLPLUS Window connect as user X and run the job:
|
| CONNECT userX/new_password
| execute dbms_job.run(1);
|
| Go back to first session (user system) and restore userX old password:
|
| ALTER USER userX IDENTIFIED BY VALUES '9F56C14116139736';
|

Always a bad idea to workaround with a hack. Better is to modify the design to avoid this.

Regards
Michel Cadot Received on Wed Apr 13 2005 - 14:39:24 CDT