DBMS_SCHEDULER. Create_job Fails with ORA-06512 ORA-27486: insufficient privileges

advertisements

_____________________________________________________________________________________________________________________

Error Description:

ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 376
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 .

Solution Description:

Grant create job privilege to the user who is trying to create the job.

Syntax:

Grant create job to <username>;

_____________________________________________________________________________________________________________________

Website Stats