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

Thread: privilege issue on OMS

Hybrid View

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    privilege issue on OMS

    I log into the OMS which run Oracle 9i, this OMS running OEM can connec to all of our instances. Last week, I upgrade one of our instance on different server from 8.1.7 to 9.2.0.4. Today, when I log into the OMS server and try to connect to this new upgrade instance and I got the message (I log in as SYSTEM):

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

    Why do I need that privilege and how come there is no problem with 8i


    thanks,

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    ahhh, different version?
    Jeff Hunter

  3. #3
    Join Date
    Oct 2003
    Posts
    312
    Jeff,

    the remote database is running on 9.2.0.4 and the OMS is running on 9.2.0.3, does it make any difference???

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    No, no, no. You upgraded from 8.x to 9.x on the instance you are trying to connected to. Find out what's different and you've found your solution.
    Jeff Hunter

  5. #5
    Join Date
    Oct 2003
    Posts
    312
    Jeff,

    how can I find out the different??? BTW, I use DUA to upgrade my database, could you please throw some light on this issue???

    thanks

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Look into the privs on both databases (dba_role_privs, dba_tab_privs) for the userid you are trying to connect as.
    Jeff Hunter

  7. #7
    Join Date
    Oct 2003
    Posts
    312
    I connect in as SYSTEM and I got the error.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by marist89
    Look into the privs on both databases (dba_role_privs, dba_tab_privs) for the userid you are trying to connect as.
    Jeff Hunter

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    closing, duplicate of 39487
    Jeff Hunter

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