Scanning objects in another user's schema

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 8
Joined: Sun 04 Dec 2011 00:10

Scanning objects in another user's schema

Post by vonbrana » Sun 04 Dec 2011 00:37

I have been given a log on for our Oracle database. The dba does not want me to have the credentials for the account that owns the schema with the objects that I need. The account that I have has been granted read access to the tables. But when I connect using EF and the devart provider, no objects show up in the wizard to select to be scanned.

Is there some way the account can be configured so that the objects of the schema I need are visible when I run the wizard to set up the EF model?

Alec von Brand

Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 05 Dec 2011 15:01

1. If you are using Entity Developer (the Devart Entity Model template, *.edml, recommended), select the "Show all users" checkbox on the "Select database objects" step of Create Model Wizard.

2. If you are working with Entity Data Model Wizard (the ADO.NET Entity Data Model template, *.edmx), it should retrieve all database objects, which are available for the current user, on the "Choose Your Database Objects" step.

Post Reply