As a prerequisite for scheduling synchronization jobs, the M_SYS user must have permission to execute the BIR_BI_FUNCTIONS package of the BIR_SPMAT schema. To grant permission, proceed as follows.
-
Launch SQL*Plus.
-
Connect as SYS.
-
Execute this command:
grant execute on BIR_SPMAT.BIR_BI_FUNCTIONS to M_SYS;