分类: Oracle
2011-06-20 11:27:22
Oracle 建议撤消 PUBLIC 对功能强大的程序包的 EXECUTE 权限
程序包 UTL_FILE
程序包 DBMS_RANDOM UTL_HTTP UTL_SMTP UTL_TCP
解决:
revoke execute on utl_file from public;
revoke execute on DBMS_RANDOM from public;
revoke execute on UTL_HTTP from public;
revoke execute on UTL_SMTP from public;
revoke execute on UTL_TCP from public;
-------------------------------------------------
EXECUTE UTL_FILE 权限 建议撤消PUBLIC对功能强大的程序包的EXECUTE 权限 程序包t('3')
解决---
[oracle@localhost pfile]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 4 12:20:30 2009
Copyright (c) 1982, , Oracle. All rights reserved.
SQL> conn /as sysdba;
Connected.
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_TCP FROM PUBLIC;
Revoke succeeded.