Seeing the DBMS_SCHEDULER jobs of another schema

[Stromgol]

USER1 has a DBMS_SCHEDULER jobs called JOB1.
I want USER2 to be able to see (and run) this job from the Jobs folder in PL/SQL developer (8.0.4.1514).

I have run:
GRANT ALTER ON USER1.JOB1 TO USER2

For USER1 the selected schema is but the job still doesn't appear in the Jobs folder.

Am I missing a permission?

 

[Marco Kalter]

Does the job appear in the all_scheduler_jobs view for user2?

 

[Stromgol]

Yes

 

[Marco Kalter]

That's odd. Does it appear in the all_objects view for user2?

 

[Stromgol]

No

 

[Marco Kalter]

Can you enable the "Use DBA views if available" preference and try again?

 

[Stromgol]

That kind of works.

With "Use DBA views if available" enabled, USER2 sees ALL jobs, not just USER1.JOB1. But that's better than nothing.
USER2 can't run the other USER1 jobs it now sees, which is fine.

Thanks!

 

[Stromgol]

I think I found another "workaround", if USER1 opens the DBMS Scheduler window directly from the Tools menu.
In the list of jobs in that window he can see USER1.JOB1 and not the other jobs.