Book a Demo

Author Topic: Oracle 10g role reqd for db import  (Read 2066 times)

dbguy

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Oracle 10g role reqd for db import
« on: December 13, 2007, 05:22:31 pm »
Hi folks,

I'm connecting to Oracle 10.2 database to reverse engineer the tables for a given user. It asks me for user ID. I give it the ID of the user and get "unable to obtain table information"
I guess that user is missing some grants? But what?
That user can see 'all_objects'...what else does it need?

As an alternative I connect as user with all rights.
This returns all db objects. But I only want objects created by user foo. So I enter foo in schema/owner box. If I uncheck the box 'include system objects' then I get zero objects. If I check it then I get the 1000's of system objects.

Bottom line is that it appears to not see any objects created by user foo. Even though if I connect as foo and select count(*) from user_objects I get the 100 or so tables, views and sequences that owner created.

What am I missing when I connect via odbc to remote 10g db?
TIA