oem提示： oracle 建议撤消 public 对功能强大的程序包 的 execute 权限 程序包-： dbms_random- utl_http- utl_smtp- utl_tcp- [ oracle @db ~]$ sqlplus / as sysdba sql*plus: release 10.2.0.4.0 - production on fri jun 12 14:20:44 2009 copyright (c
oem提示：oracle 建议撤消 public 对功能强大的程序包的 execute 权限
程序包-： dbms_random- utl_http- utl_smtp- utl_tcp-
[oracle@db ~]$ sqlplus / as sysdba
sql*plus: release 10.2.0.4.0 - production on fri jun 12 14:20:44 2009
copyright (c) 1982, 2007, oracle. all rights reserved.
connected to:
oracle database 10g enterprise edition release 10.2.0.4.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
sql> revoke execute on utl_file from public;
revoke succeeded.
sql> revoke execute on dbms_random from public;
revoke succeeded.
sql> revoke execute on utl_http from public;
revoke succeeded.
sql> revoke execute on utl_smtp from public;
revoke succeeded.
sql> revoke execute on utl_tcp from public;
revoke succeeded.
sql>
========================================
收回后会出现许多无效的包，下面的你可能会用到。
sql>grant execute on utl_file to public;
sql>grant execute on dbms_random to public;
sql>grant execute on utl_http to public;
sql>grant execute on utl_smtp to public;
sql>grant execute on utl_tcp to public;
========================================
查看public所拥有权限：
sql> select table_name from dba_tab_privs where grantee='public' and privilege='execute' and table_name like 'utl%';
========================================
errors in file /u01/oracle/admin/gstsms/bdump/gstsms_j002_21665.trc:
ora-12012: error on auto execute of job 90541
ora-04063: ora-04063: package body oracle_ocm.mgmt_db_ll_metrics has errors
ora-06508: pl/sql: could not find program unit being called: oracle_ocm.mgmt_db_ll_metrics
ora-06512: at line 1
has errors
to give execute privilege to the utl_file, run the following sql statement:
sql>grant execute on sys.utl_file to oracle_ocm;
参考地址：http://download.oracle.com/docs/html/b32294_08/troubleshooting.htm