When you try to connect a database through enterprise manager you may have an error like:
Error "The application requires more database privileges than you have currently been granted. Click on Help to get more version specific information."
even your user has connect role.

Enterprise maneger requires
SELECT_CATALOG_ROLE role or SELECT ANY DICTIONARY privilege to connect through EM. But what they mean and what is the difference between them.

  • First of all SELECT_CATALOG_ROLE is a role and SELECT ANY DICTIONARY is a privilege. (Remember roles need relogin or explicit set role from a session to take affect whereas the granting of privileges take immediate affect.)
  • SELECT_CATALOG_ROLE role provides access to all SYS views only. (static dictionary views (dba_) & dynamic performance views (v$)
  • If both SELECT ANY DICTIONARY and SELECT ANY TABLE privilege is enabled then it allow access to all SYS and non-SYS objects. (If O7_DICTIONARY_ACCESSIBILITY = FALSE; if it is TRUE, SELECT ANY TABLE privilege is already enough!!)

22 Responses so far.

  1. mamo says:

    Thanx alot about this great information dear
    but i'm new user to oracle
    can you explain to me simply how i can give all privillages )SELECT_CATALOG_ROLE role or SELECT ANY DICTIONARY) ???

  2. santhosh says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion HCM Online Training

  3. Anonymous says:

    A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
    Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training

  4. shilpi says:

    Download and install and office setup from office.com/setup . log in and enter office 25 digit product key to activate your office product. if you are new user then you need to create a office account to get more benefits of office.com/setup subscription. Ms office is a new sensatin office.com/setup in the market that left every body awestruck with its best products.
    office.com/setup
    office.com/setup
    office.com/setup
    office.com/setup
    office.com/setup
    office.com/setup
    office.com/setup

  5. shilpi says:

    Norton Antivirus provides protection from viruses, malware, online threats without harming device performance. It also blocks harmful websites. You can get Norton.com/setup product from retail store and also download and install Norton Antivirus with product key from Norton.com/setup. And to do this, you can visit the website given by us at Norton.com/setup or link. Our entire team is available to help you.
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup

  6. shilpi says:

    Amazon Prime TV, and MyTV code. To register your device on the Amazon website you go to our website and enter the given code. The program requires the customer to have an Amazon account and a streaming device or TV. Amazon Prime Video is available on almost all streaming devices like Roku, Amazon Fire TV, Chromecast. For this, you just have to go to Amazon Amazon.com/mytv with the help of the amazon activation code. You can visit our website for details of the entire process. You can do this by installing the Amazon.com/mytv Video application on your smart TV, or the digital media player or video game console connected to your TV by visiting the link provided by us in the de cription.or more information, you can contact our team at Amazon.com/mytv and get more and more information.
    amazon.com/mytv

  7. pooja says:

    Norton Antivirus provides protection from viruses, malware, online threats without harming device performance. It also blocks harmful websites. You can get Norton.com/setup product from retail store and also download and install Norton Antivirus with product key from Norton.com/setup. And to do this, you can visit the website given by us at Norton.com/setup or link. Our entire team is available to help you.

  8. pooja says:

    Download the McAfee antivirus Mcafee.com/activate key to protect your device from being spoiled by the harmful viruses as it starts finding the way to remove them from the device as soon as possible.If you have code, you enter mcafee activation code and if you have any problems redeeming your activation code, you can contact our team through this Mcafee.com/activateactivate and get the information Can.For more information, you can visit our website mcafee.com/activate and enjoy.

  9. Sarika A says:

    Good blog very informative on Oracle Technology. I am expecting many more thanks for this useful blog.

    Oracle Fusion HCM Training
    Workday Training
    Okta Training
    Palo Alto Training
    Adobe Analytics Training

  10. shiviwebh says:

    "Microsoft 365 is the productivity cloud designed to help you pursue your passion and run your business. More than just apps like Word, Excel, PowerPoint, Microsoft 365 brings together best-in-class productivity apps with powerful cloud services, device management, and advanced security in one, connected experience.

    office.com/setup"

  11. yuvi says:


    You can download and install norton setup from Norton.com/setup . Norton may receive annual renewal billing, cancellations, refunds, subscriptions, credit card updates, purchases by Norton membership. Visit Norton.com/setup to activate or renew your Norton membership. And a valid Norton membership ensures that your security is always updated. You should activate or renew your subscription before the trial or membership period ends so that all Norton features can continue to be used and your computer is protected. For more information, you can contact our team at Norton.com/setup and get more and more information.

  12. You can download and install norton setup from Norton.com/setup
    . Norton may receive annual renewal billing, cancellations, refunds, subscriptions, credit card updates, purchases by Norton membership. Visit Norton.com/setup
    to activate or renew your Norton membership. And a valid Norton membership ensures that your security is always updated. You should activate or renew your subscription before the trial or membership period ends so that all Norton features can continue to be used and your computer is protected. For more information, you can contact our team at Norton.com/setupand get more and more information.

    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup

  13. shilpiweb says:

    Kaspersky Anti-Virus features include real-time protection, detection and removal of viruses, trojans, worms, spyware, adware, keyloggers, malicious tools and auto-dialers, as well as detection and removal of rootkits.
    Kaspersky.com/activation
    Kaspersky.com/activation
    Kaspersky.com/activation
    Kaspersky.com/activation
    Kaspersky.com/activation
    Kaspersky.com/activation

  14. shilpiweb says:


    Norton Antivirus provides protection from viruses, malware, online threats without harming device performance. It also blocks harmful websites. You can get Norton.com/setup product from retail store and also download and install Norton Antivirus with product key from Norton.com/setup. And to do this, you can visit the website given by us at Norton.com/setup or link. Our entire team is available to help you.
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup

  15. shiviweb says:

    Select the office product you want to download and install on the device. Go to the office.com/setup option. To upgrade Office, press on the products of office.com/setup and start downloading and installing Office products on the device.log in and enter office 25 digit product key to activate your office product. if you are new user then you need to create a office account to get more benefits of office.com/setup subscription.

    office.com/setup
    office.com/setup

  16. shiviweb says:

    Roku Streaming players are an increasingly advantageous roku.com/link and financially savvy approach to sit in front of the TV. Simply plug it into your TV, associate with the web, set up a Roku record, and start spilling your top choices.Roku gadgets are easy to set-up and simple to-utilize.
    roku.com/link They accompany a straightforward remote, and incredible highlights like Roku Search which makes it easy to discover what you need to watch.
    roku.com/link
    roku.com/link
    roku.com/link

  17. shiviweb says:

    Norton Antivirus provides protection from viruses, malware, online threats without harming device performance. It also blocks harmful websites. You can get Norton.com/setup product from retail store and also download and install Norton Antivirus with product key from Norton.com/setup. And to do this, you can visit the website given by us at Norton.com/setup or link. Our entire team is available to help you.

    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup
    Norton.com/setup

  18. Keerthi55 says:

    I really like and appreciate your post.Really thank you! Fantastic.
    office 365 online training
    office 365 training

  19. hbogo movies thank you so much for this fabulous information

  20. If you have purchased a macbook for your own use, it is very necessary to take the proper protection as well to protect your macbook from any dangerous threats. By not taking any more time it is true. Webroot has been proven so far the best antivirus software program as it has various discounted plans and it's better for devices as well. But to bring the same topic there are some complications that can come along the way on the topic states can't open webroot on mac.

    CAN'T OPEN WEBROOT ON MAC

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -