Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

grant user_jobs to another account

user517698Mar 16 2007 — edited Mar 18 2007
Hi ,

I can see from my own account A a list of jobs from user_jobs as these were scheduled by account A

but how can i allow account B(who does not have any scheduled jobs) to see the same list of jobs from user_jobs

i tried granting select on user_jobs to B but still
B sees nothing from user_jobs

select * from user_jobs

pls advise

tks & rgds
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2007
Added on Mar 16 2007
8 comments
861 views