Skip to Main Content

Database Software

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!

what user does dbms_scheduler run as?

EmuMay 28 2010 — edited Jun 22 2010
I have a very odd problem. I have a scheduled job which calls a proc. this proc is set to execute with the definers privs. this works fine when I execute the proc or the dbms_scheduler.run_job as another database user. However when the scheduler runs, the proc does not appear to have the owners permissions!

This has only been an issue when there is a database link involved.

Anyone know why this would be?

Can anyone tell me which database user dbms_scheduler runs as and if this can be changed? I really need the scheduler to run with the privs of a certain user and really I need it to be that user - to have same password/username as the user on the other database for the database link. (I'm wanting to periodically copy data from one database to another)

anyway help much appreciated!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2010
Added on May 28 2010
2 comments
4,115 views