oracle 执行job 权限,在GRANT CREATE JOB，CREATE EXTERNAL JOB之后，DBMS_SCHEDULER，ORA-27486缺少Oracle权限...

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL>

SQL> create user myUser identified by password default tablespace theData temporary tablespace temp;

User created.

SQL> grant connect, resource to myUser;

Grant succeeded.

SQL> GRANT READ,WRITE ON DIRECTORY tmp TO myUser;

Grant succeeded.

SQL> GRANT CREATE JOB TO myUser;

Grant succeeded.

SQL> GRANT CREATE EXTERNAL JOB TO myUser;

Grant succeeded.

SQL> connect myUser/password

Connected.

SQL>

SQL>

1 CREATE PROCEDURE shellScript

2 AS

3 /*-----------------------*/

4 v_sql UTL_FILE.FILE_TYPE;

5 v_shell UTL_FILE.FILE_TYPE;

6 /*============