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>;

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Rocky mount viewed 'How to Get Oracle Redo Log Files, Members, Size, N' 2 hrs 26 mins ago

A visitor from Tennessee viewed 'How to create and remove soft link (symbolic) in S' 3 hrs 12 mins ago

A visitor from Monterrey viewed 'Data Pump impdp expdp : SQLFILE option to extract ' 3 hrs 17 mins ago

A visitor from Hamburg viewed 'Oracle: SQL Query to Find out Index Name, Column N' 3 hrs 24 mins ago

A visitor from Germantown viewed 'Export and Create Excel File from Oracle SQL Query' 3 hrs 41 mins ago

Real-time | Get Script | More Info