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!

Privileges needed to run a job?

do417019ttMay 31 2006 — edited Jun 12 2006

I have a database procedure that I have put in the 10g R2 job queue with a disabled status. I would like to allow a user to pass some parameters to the database procedure using the dbms_scheduler.set_job_argument_value and then enable the job with the dbms_scheduler.enable to run the job, but when I try this the user gets access errors. What privileges do I need to grant to a user to get this to work?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2006

Added on May 31 2006

#database-key-features, #scheduler

1 comment

1,542 views