Oracle recommends that you revoke EXECUTE privileges on powerful packages from PUBLIC

Dear Friends,

In Oracle Enterprieses manager --> Policy Violations --> I got messages like

Oracle recommends that you revoke EXECUTE privileges on powerful packages from PUBLIC

Please help me out for above suggestion and how to resolve.

Thanks & Regards,
Muzammil

umm it tells you what the problem and how to fix it - what dont you understand?

what packages i have to execute.

query from dba_tab_privs where grantee='PUBLIC' and privilege='EXECUTE' and identify what are the "powerful packages".

Thanks,

Dear Vijay,

When I trying to check dba_tab_priv i got following

SQL> select count(*) from dba_tab_privs where grantee='PUBLIC' and privilege='EXECUTE';

COUNT(*)
----------
19159

ex:
GRANTEE OWNER
------------------------------ -----
TABLE_NAME
------------------------------
PUBLIC SYS
/de7ce975_JComponentIntVector

PUBLIC SYS
/ee702bf1_JComponentKeyboardSt

PUBLIC SYS
javax/swing/UIManager$


Please help me how to execute.

Thanks in advance.

Regards,
dba

Revoke the EXECUTE privilege from PUBLIC for the following packages.

UTL_FILE
UTL_SMTP
UTL_TCP
UTL_HTTP
DBMS_RANDOM

still OEM shows the policy violation then follow this link ...

http://dba-brent.blogspot.com/2007/0...of-policy.html

Thanks,

Dear Vijay,

I used following steps I got

$ emctl clearstate agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
clearstate failed with ret=-10
$

Please advice.

Thanks in advance.

Regards,