-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|