Hello, I need to give privileges to a scheme so that it can create a chain, the following permissions are granted:
grant create job to user;
grant create external job to user;
With this the user created a job but not the chain where the following error appears:
ORA-06512: in "SYS.DBMS_CHAIN_INVOKER", line 91
ORA-06512: in "SYS.DBMS_ISCHED", line 1261
ORA-06512: in "SYS.DBMS_CHAIN_INVOKER", line 82
ORA-06512: in "SYS.DBMS_SCHEDULER", line 1720
where DBMS_SCHEDULER has permissions.
All this is new, there are no duplicate or created jobs as well as chains.