-
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,
-
-
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???
-
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
-
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
-
Look into the privs on both databases (dba_role_privs, dba_tab_privs) for the userid you are trying to connect as.
Jeff Hunter
-
I connect in as SYSTEM and I got the error.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|