Grant oracle job from one schema to another
A-KJan 19 2010 — edited Jan 20 2010Hi,
I have two schemas A and B.
Grant on all objects of schema A has been given to schema B.
There two jobs scheduled in schema A.
Now i wish to check the status of these job's from schema B.
I know if schema B is given select grant on dba_jobs then schema B can check the status of the jobs running in schema A.
But i dont want to give grant over dba_jobs to schema.
Is there some other way to do this ?
Is there some option, where in we could give grant over jobs like other objects ( tables or procedures ) ?
Thanks.