Skip to Main Content
  • Questions

  • Change the creator of a dbms_scheduler job

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Wolfgang.

Asked: August 03, 2016 - 11:53 am UTC

Last updated: August 04, 2016 - 12:19 pm UTC

Version: 11.2

Viewed 10K+ times! This question is

You Asked

Hello,

is it possible to change the creator of a dbms_scheduler job, so it is executed with the rights of another user?

Regards Wolfgang

and Chris said...

I'm not aware of a way to do this. You'll need to drop and re-create the job.

Note - if the original creator has "create any job", it can create the job in the target schema. Just prefix the job name with the desired schema.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Wolfgang, August 04, 2016 - 10:49 am UTC

Chris,
thanks for your response. Unfortunately using the schemaXY.jobname does not work as you intended.
According to the docs: Jobs are executed with the privileges of the schema in which the job is created
So the owner ist SchemaXY but when SchemaAB has created the job (with the create any job grant) it runs with the privileges of SchemaAB.
SchemaAB is the JOB_CREATOR in dba_scheduler_jobs.
Chris Saxon
August 04, 2016 - 12:19 pm UTC

Ah, thanks for the correction.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.