After upgrading from 12c to 19C getting ORA-01031: insufficient privileges
Hi , I am facing an issue after upgrading from 12c to 19c. I get issues when executing the below :
BEGIN
DBMS_SCHEDULER.define_chain_step (
'SCHEDULE.TEST_SCHDULER',
'STEP' || '1' ,
'SCHEDULE.TEST_SCHDULER' || '_PGM' || '1');
END;
/
BEGIN
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_CHAIN_INVOKER", line 291 -------> Introduced in 19c
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 275
ORA-06512: at "SYS.DBMS_CHAIN_INVOKER", line 287
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1762
ORA-06512: at line 2
I have granted execute priv to public and directly to the user executing the above.
Has anyone come across this issue?