August 1, 2012 / doganay
DBMS_SCHEDULER.Create_job Fails with ORA-06512 ORA-27486: insufficient privileges
"SYS.DBMS_ISCHED", 06512, 10.2, 10.2.0.4, 10.2.0.4 client, 10.2.0.4 end of life, 10.2.0.4 patch, 10.2.0.4.0, 10.2.0.5, 10.2.0.5 patchset, 10.2.0.5.0, 10.2.0.5.3, 10.2.0.5.6, 10.2.0.5.7, 11.1, 11.1.1.7, 11.1.2, 11.2, 11.2.0.2, 11.2.0.3, 11.2.0.3.0, 11.2.0.4, 27486, 6512, about oracle, about oracle 11g, about oracle 11g database, about oracle 11g documentation, about oracle database, about oracle database 10g, about oracle database 11g, about oracle database architecture, about oracle database management system, about oracle database tutorial, architecture of oracle database 11g, create job, create_job, Database Reference, DBMS_ISCHED, DBMS_SCHEDULER, DBMS_SCHEDULER.create_job, DBMS_SCHEDULER.Create_job Fails, DBMS_SCHEDULER.Create_job Fails with ORA-06512 ORA-27486: insufficient privileges, execute, Express Edition Oracle, features of oracle database 11g, features of oracle database 11g contribute to reduce storage costs, features of oracle database 11g release 2, Frequently Ask Questions, grant, grant create job, grant create job to, grant execute, grant execute on, grant execute on DBMS_SCHEDULER, grant execute on DBMS_SCHEDULER to, in oracle, insufficient privileges, line, line 99, metalink note, New Features, New Features 10g, New Features 11g, New Features in 10g, New Features in 11g, New Features Oracle 10.1.0.2.0, New Features Oracle 10.2.0.1.0, New Thing What I learn EVERY DAY, Off Topic, ORA, ora-00600, ora-00600 error solution, ora-00600 internal error code, ora-00600 internal error code arguments, ora-00600 internal error code arguments solution, ora-00600 internal error code solution, ora-00600 solution, ORA-06512, ORA-06512: at "SYS.DBMS_ISCHED", ORA-07445, ora-07445 exception encountered core dump access_violation, ora-07445 exception encountered core dump address not mapped to object, ora-07445 exception encountered core dump sigsegv, ora-07445 exception encountered core dump sigsegv address not mapped to object, ora-07445 exception encountered core dump sigsegv unknown code, ORA-27486:, ORA-27486: insufficient privileges, oracle, oracle 10.2, oracle 10.2.0.4, oracle 10.2.0.4 client, oracle 10.2.0.4 end of life, oracle 10.2.0.4 patch, oracle 10.2.0.4.0, oracle 10.2.0.5, oracle 10.2.0.5 patchset, oracle 10.2.0.5.0, oracle 10.2.0.5.3, oracle 10.2.0.5.6, oracle 10.2.0.5.7, Oracle 10gr2, oracle 11.1, oracle 11.1.1.7, oracle 11.1.2, oracle 11.2, oracle 11.2.0.2, oracle 11.2.0.3, oracle 11.2.0.3.0, oracle 11.2.0.4, oracle 11g, oracle 11g documentation, oracle 11g documentation release 2, oracle 11g new features, oracle 11g new features for dba, Oracle 11gr1, oracle 11gr2, Oracle 9ir2, oracle as, oracle as a service, oracle as a service linux, oracle dba, Oracle Error, oracle for, oracle for beginners, oracle for beginners pdf, oracle for beginners tutorial, oracle for linux, oracle for linux 5, oracle for linux 6, oracle in, Oracle on LINUX, Oracle on UNIX, Oracle on Windows, Oracle Product, oracle sql, oracle sql developer, oracle sql queries, oracle sql queries examples, oracle sql queries examples with answers, oracle sql tutorial, oracle sql tutorial for beginners, oracle sql tutorial with examples, oracle tutorial, oracle tutorial for beginners, oracle tutorial for beginners pdf, oracle tutorial pdf, oracle tutorial pdf for beginners, oracle tutorial with examples, oracle tutorial with examples pdf, oracle with, patch, Performance, pl/sql, Security, solution ora-00600 internal error code arguments, sql oracle, sql oracle developer, sql oracle tutorial, sql oracle tutorial beginners, sql oracle tutorial pdf, sql oracle tutorial queries, sys, Table, Tablespaces, Technical Question, the oracle, the oracle answers, the oracle answers questions, the oracle answers yes no, the oracle answers your questions, UPGRADE, what is oracle, what is oracle database, what is oracle database 10g, what is oracle database 10g client, what is oracle database 10g client release 2, what is oracle database 10g express, what is oracle database 10g express edition, what is oracle database 11g, what is oracle database 11g express edition, what is oracle database 11g release 1 client, what is oracle database server
Problem:
exec DBMS_SCHEDULER.create_job(... ORA-27486: insufficient privileges ORA-06512: at "SYS.DBMS_ISCHED", line 99 ORA-06512: at "SYS.DBMS_SCHEDULER", line 268 ORA-06512: at line 2
Solution:
grant execute on DBMS_SCHEDULER to <myuser>; grant create job to <myuser>;
Filed under ORACLE
Leave a comment