Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    9

    Unanswered: Connecting from 9i dbastudio to 10g database.

    We've migrated a 9i database using exp/imp to 10g on a different server. You can connect fine to the 10g database using the 10g dbastudio/SQL*Plus and from 9i SQL*Plus, but when you try to connect using the 9i dbastudio it gives the following error:

    This application requires you have been granted the SELECT ANY DICTIONARY privilege. Contact your DBA to grant you this privilege.

    If I check the user account, they DO have the SELECT ANY DICTIONARY privilege. And yes, O7_DICTIONARY_ACCESSIBILITY is set to TRUE.

    Any ideas? I can get people to start using the 10g client, but I still think the 9i clients should be able to connect...

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    i suggest upgrading to 10g clients.

    How could they possibly account for forward compatibility?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •