-
Execute privilege
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.
-
Granting exec privs does not invalidate objects.
"grant execute" syntax is wrong.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Sorry mistaken, revoking execute privilege creating invalid objects.
thanks,
Last edited by iris; 12-13-2010 at 08:50 AM.
-
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
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
sorry not clear, does force option causing invalid objects? If yes how to revoke the public privilege.
please explain.
thanks,
-
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
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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
|