privilege issue on OMS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: privilege issue on OMS

  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,
    Share on Google+

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    ahhh, different version?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

  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???
    Share on Google+

  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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

  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
    Share on Google+

  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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

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

  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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    closing, duplicate of 39487
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

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