DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Execute privilege

  1. #1
    Join Date
    Mar 2008
    Posts
    140

    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.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.

  3. #3
    Join Date
    Mar 2008
    Posts
    140
    Sorry mistaken, revoking execute privilege creating invalid objects.


    thanks,
    Last edited by iris; 12-13-2010 at 08:50 AM.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.

  5. #5
    Join Date
    Mar 2008
    Posts
    140
    sorry not clear, does force option causing invalid objects? If yes how to revoke the public privilege.

    please explain.


    thanks,

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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
  •  


Click Here to Expand Forum to Full Width