How to view other schema's job status ?
Rene W.Dec 10 2007 — edited Dec 10 2007Hi,
My application is in schema A. User B has just enough rights to do specific tasks in A. One of them is to call a function that creates a job in schema A.
The view user_jobs in A shows the job.
How can I make this job visible to user B without granting B access to dba_jobs?
I tried granting select on a.user_jobs to B and hoped that the job would show up in B's all_jobs view but that did not work.
Any ideas?
Rene