Database error - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Database error

  1. #11
    Join Date
    May 2008
    Posts
    18
    Here is the list of objects on which I have granted permission so far manually:



    DBMS_REGISTRY

    DBMS_REGISTRY_SERVER

    XML_SCHEMA_NAME_PRESENT

    SYS_STUB_FOR_PURITY_ANALYSIS

    UTL_SYS_COMPRESS

    DBMS_SPACE_ADMIN

    DBMS_TRANSACTION_INTERNAL_SYS

    DBMS_INTERNAL_LOGSTDBY





    Please advice what can be done.



    Thank you
    Last edited by aparnakambha; 05-30-2008 at 03:05 AM.

  2. #12
    Join Date
    Jan 2007
    Posts
    231
    grant execute any procedure to that user.,

    if it fails .,

    grant sys and check

  3. #13
    Join Date
    May 2008
    Posts
    18
    The user is having EXECUTE_CATALOG_ROLE granted to it....

  4. #14
    Join Date
    May 2008
    Posts
    18
    The user is having EXECUTE_CATALOG_ROLE granted to it....

  5. #15
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by aparnakambha
    The user is having EXECUTE_CATALOG_ROLE granted to it....
    So what?
    You keep saying whatever pop-ups on your head instead of answering our questions and consider our suggestions. Very hard to help somebody doesn't helps him/herself.
    I'm officialy giving up on you. Sorry.
    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.

  6. #16
    Join Date
    May 2008
    Posts
    18
    Hey I will change the script like this :

    declare

    own varchar2(100);

    nam varchar2(100);

    cursor pkgs is

    select owner, object_name

    from dba_objects

    where owner='';

    begin

    open pkgs;

    loop

    fetch pkgs into own, nam;

    exit when pkgs%notfound;

    sys.dbms_shared_pool.keep(own || '.' || nam, 'P');

    end loop;

    end;

    plz help me out..plzzzzzzzzzzzzzzzzzz


    But y am I getting this error......

  7. #17
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    its protecting you from the most monumentally stupid script ever, count yourself lucky

  8. #18
    Join Date
    May 2008
    Posts
    18
    The user is having EXECUTE_CATALOG_ROLE granted to it....

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