Page 1 of 1

Create from database requires login to be table owner

Posted: Thu 13 Aug 2009 13:57
by brent@work
In doing a proof of concept with LINQ to Oracle and using the Entity Developer we're finding that when reverse engineering an Oracle database none of the objects (i.e. tables, views, etc.) are appearing in the designer - everything is always empty. The problem seems to be with the queries that entity developer issues to populate the table list as it contains a predicate like this:

OWNER='LOGIN NAME USED IN CONNECTION'

Is there anyway around this? In our environment developers don't (and won't) have the owner login information which would seem to mean that this tool is not a viable option for us.

Thanks

Posted: Fri 14 Aug 2009 12:49
by AndreyR
Please check the "Show all users" checkbox. This will enable you to see the tables owned by other users.
If you have the select permission for these objects, they will be added to the model.