Oracle recommends revoking the execute permission of the public to powerful packages.

Oracle recommends revoking the public pair.ProgramExecute Permission of the package

 

Package utl_file

Package dbms_random utl_http utl_smtp utl_tcp

 

Solution:

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;

-------------------------------------------------

(1): Bug:

On the EM-console, You can see ----

detailed information on rule creation

Execute utl_file permissionOracleWe recommend that you revoke the Execute Permission package T ('3') from the public to a powerful package ')

 

 

(2 ):

Solution ---

[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,2005, 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.