Problem with lot of schemas
Posted: Wed 27 Oct 2010 11:46
Hi
I have a problem when i connect to oracle database that have a lot of users. In my case, there are about 100.000 users, and each has one logon-trigger. When I create a connection in entity developer, and click "show all objects" because I need to map an object that is in another schema, entity developer loads all users and eats up all the memory in my machine. What is should do is only show schemas that contains objects that I have access to like Visual Studio server explore does.
Is there somewhere an option that I can set to stop loading all users/schemas, because otherwise I always have to log on as each schema owner.
Regards,
Haukur
I have a problem when i connect to oracle database that have a lot of users. In my case, there are about 100.000 users, and each has one logon-trigger. When I create a connection in entity developer, and click "show all objects" because I need to map an object that is in another schema, entity developer loads all users and eats up all the memory in my machine. What is should do is only show schemas that contains objects that I have access to like Visual Studio server explore does.
Is there somewhere an option that I can set to stop loading all users/schemas, because otherwise I always have to log on as each schema owner.
Regards,
Haukur