Database – Oracle Database 23AI
Cause :
An attempt was made to perform a scheduler operation without the required privileges.
Action :
Ask a sufficiently privileged user to perform the requested operation, or grant the required privileges to the proper user(s).
ERROR :
BEGIN
DBMS_SCHEDULER.create_job (
job_name => ‘REFRESH’,
job_type => ‘PLSQL_BLOCK’,
job_action => ‘BEGIN DBMS_RESH(”QA”, ”F”); END;’,
start_date => SYSTIMESTAMP,
repeat_interval => ‘FREQ=SECONDLY; INTERVAL=30’,
enabled => TRUE
);
END;
Error report –
ORA-27486: insufficient privileges
ORA-06512: at “SYS.DBMS_ISCHED”, line 191
ORA-06512: at “SYS.DBMS_SCHEDULER”, line 332
ORA-06512: at line 2
27486. 00000 – “insufficient privileges”
*Cause: An attempt was made to perform a scheduler operation without the required privileges.
*Action: Ask a sufficiently privileged user to perform the requested operation, or grant the required privileges to the proper user(s).
Solution :
This error is related to the user privileges. Grant the privileges for the related user as follows.
[oracle@ora23ai-db ~]$ sqlplus sys/*****@SIT as sysdba
SQL*Plus: Release 23.0.0.0.0 – Production on Thu Mar 13 13:40:06 2025
Version 23.4.0.24.05
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 – Production
Version 23.4.0.24.05
SQL> grant execute on DBMS_SCHEDULER to SCHEMA_NAME;
Grant succeeded.
SQL> grant create job to SCHEMA_NAME;
Grant succeeded.