i have a user who's whole purpose is to manage jobs.
i granted him the scheduler admin and manage scheduler role and explicitly the create job privilege (since role privileges are not available within a package).
the package conteining the problematic code is authid definer (as it should be) since other users should be able to use it.
the user is also the owner of the jobs.
the problem is that i'm getting an insufficient privileges exception when trying to stop the job with the force option enabled (only) within the package.
dbms_scheduler.stop_job('myuser.myjob',TRUE);
i don't want to grant the user CREATE ANY JOB privilege. this user is used by a database operator who should not be able to run code as any user in the database.
i would also like to revoke this privilage from the scheduler admin role.
thanks !