Execute privilege

[iris]

Does granting Execute privilege to public results in invalid objects, Iam facing this problem.

grant execute on utl_http from public force;
grant execute on utl_tcp from public force;
grant execute on utl_file from public force;
grant execute on utl_inaddr from public force;
grant execute on utl_smtp from public force;
grant execute on utl_dbws from public force;
grant execute on dbms_lob from public force;
grant execute on dbms_random from public force;
grant execute on dbms_obfuscation_toolkit from public force;
grant execute on dbms_crypto_toolkit from public force;
grant execute on dbms_advisor from public force;
grant execute on dbms_ldap from public force;
grant execute on dbms_ldap_utlfrom public force;
grant execute on dbms_job from public force;
grant execute on dbms_scheduler from public force;
grant execute on dbms_ddl from public force;
grant execute on dbms_epg from public force;
grant execute on dbms_xmlgen from public force;
grant execute on dbms_aw_xml from public force;
grant execute on ctxsys.drithsx from public force;
grant execute on ordsys.ord_dicom from public force;

Any help to resolve this, I have to revoke them for security.

[PAVB]

Granting exec privs does not invalidate objects.
"grant execute" syntax is wrong.

[iris]

Sorry mistaken, revoking execute privilege creating invalid objects.


thanks,

[PAVB]

That's the nature of "FORCE" option - are you revoking privs from user-defined type objects?

Check Oracle documentation:
Oracle® Database SQL Reference
10g Release 2 (10.2)
Part Number B14200-02

[iris]

sorry not clear, does force option causing invalid objects? If yes how to revoke the public privilege.

please explain.


thanks,

[PAVB]

It all depends on the kind of object you are revoking privs - in most cases you do not need "force" option.
Please check:
Oracle® Database SQL Reference
10g Release 2 (10.2)
Part Number B14200-02
Here: http://www.stanford.edu/dept/itss/do...ments_9020.htm