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

Thread: create user in 10g

  1. 07-12-2006, 03:09 AM #1
    helloravi
    helloravi is offline Junior Member
    Join Date
    Aug 2000
    Posts
    33

    create user in 10g

    I had created a user in 10g and granted DBA privileges. While connecting the message says "This application requires you have been granted the SELECT ANY DICTIONARY privilege - Contact Your DBA" - Please help how to resolve this.

    Thanks in advance
    Ravi
    Reply With Quote Reply With Quote
  2. 07-12-2006, 04:23 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well it tells you explictly what it wants, so whats the problem?

    privleges through roles wont work here
    Reply With Quote Reply With Quote
  3. 07-12-2006, 05:39 AM #3
    helloravi
    helloravi is offline Junior Member
    Join Date
    Aug 2000
    Posts
    33
    I had granted the privilege - still the same message displays.
    Reply With Quote Reply With Quote
  4. 07-12-2006, 06:05 AM #4
    ebrian
    ebrian is offline Senior Member
    Join Date
    Apr 2006
    Posts
    377
    While connecting thru what?? I'm assuming your talking about OEM. What version of OEM are you using?
    Reply With Quote Reply With Quote
  5. 07-12-2006, 07:56 AM #5
    helloravi
    helloravi is offline Junior Member
    Join Date
    Aug 2000
    Posts
    33
    OEM version 9.2.0.1.0.
    Reply With Quote Reply With Quote
  6. 07-12-2006, 08:35 AM #6
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    how did you grant the privelege
    Reply With Quote Reply With Quote
  7. 07-12-2006, 08:53 AM #7
    ebrian
    ebrian is offline Senior Member
    Join Date
    Apr 2006
    Posts
    377
    That version of OEM doesn't support 10g.
    Reply With Quote Reply With Quote
  8. 07-20-2006, 07:30 AM #8
    helloravi
    helloravi is offline Junior Member
    Join Date
    Aug 2000
    Posts
    33
    ebrian: Could you send me which version of OEM will support ?
    Reply With Quote Reply With Quote
  9. 07-20-2006, 07:36 AM #9
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    the 10g one
    Reply With Quote Reply With Quote
  10. 07-20-2006, 10:04 AM #10
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Put more trust in Oracle's backward compatability than its forward compatability.

    I recommend using the latest stable version of OEM, agents and listeners. Don't let your db version get ahead of your tools.

    Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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