I am for the first time using dbms_scheduler instead of dbms_job.
We have a situation where several users need privilege to run and alter/ drop a job created with dbms_scheduler.
The job runs and I am able to administrate as creator/owner it but is not able to grant privileges to other users.
I have executed:
- Grant create any job to <user
- Grant manage scheduler to <user>
but without success.
When reading the documentation is seem it should be possible to grant privilege on a job using grant alter my_job to <user> but I only get ORA-00990: missing or invalid privilege
I have tried using dbms_scheduler.create_job.
Do I have to use dbms_scheduler.create_program?
Using 11.2.0.2.0 (linux)
Have I missed something fundamental?
Regards Niclas Eklund