Page 1 of 1

Scanning objects in another user's schema

Posted: Sun 04 Dec 2011 00:37
by vonbrana
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?

Thanks,
Alec von Brand
MCPS

Posted: Mon 05 Dec 2011 15:01
by Shalex
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.