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

下面是一个案例：

SQL>GRANT EXECUTE ON SYS.UTL_FILE TO ORACLE_OCM;

参考地址：http://download.oracle.com/docs/html/B32294_08/troubleshooting.htm