DBMS_JOB: mysterious behavior of DD view ALL_JOBS

Hello!

I have written a stored procedure to create a job. When another user calls this procedure the job is created under the context of user SCOTT. When logged in as SCOTT I am able to see the job just created via view ALL_JOBS or USER_JOBS. But when I try to connect as the user who called the stored procedure I am not able to see this job. Even when I write a stored procedure under the context of user SCOTT and call it as another user I get no result from this table.

So how can the other user have a look at the jobs he himself created?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 04 1999 - 02:50:49 CST