Devart Forums

We are using dotconnect for oracle and had to move to a read only Oracle user for our application per company policy.

Even though the account has permissions to read all the tables and views (the only thing it needs to do for this app) we are getting ORA-00942: table or view does not exist.

Snippet from our edmx:


Snipped from web.config:


Any ideas on this?

I should note that we are moving into another environment also for testing.

Could this be a licensing issue?

The reason of the problem seems to be the Schema name
Remove the Schema element and everything should work correctly.

I still get an error after removeing the 'Schema=' property. Although this time it is a:

System.ServiceModel.DomainServices.Client.DomainServiceFault

Pardon my lack of oracle expertise but doesn't the application need to know the name of the schema that it is querying from?

Is there another part of the edmx or connect string that this is specified?

If Entity Set does not have the Schema attribute specified, the current schema is used.
As for the DomainServiceFault class, there should be more information concerning this error, this is a general class just wrapping the communication error.

It turns out there were some hardcoded non-EF queries which didn't specify the schema, so they failed when the user was different than the schema owner.

The Schema="SCHEMA_OWNER" is needed for our EF queries. Thanks

Well I thought this was resolved it works with the new account locally, but when I move to the test environment, I get this now:

error 0175: The specified store provider cannot be found in the configuration, or is not valid.. ---> System.Data.MetadataException: Schema specified is not valid. Errors: OracleEntityModel.ssdl(2,88) : error 0175: The specified store provider cannot be found in the configuration, or is not valid.

The app works after I installed dotconnect on the test server. However, we probably can't do this in production.

Pardon my ignorance but what's the best way to include our needed dotconnect binaries in our application deploy without installing the full package on the server?

You should put the Devart.Data, Devart.Data.Oracle, and Devart.Data.Oracle.Entity assemblies in the Bin folder of your application (or place these assemblies in Global Assembly Cache).
Make sure that your application is licensed correctly (take a look at the Licensing article for more information).
Register the dotConnect for Oracle provider as well: This information is available in the Deployment article.

Even after removing the Schema=[schema owner] we still get the error telling us the table does not exists :
We are currently unable to re-use an entity framework project on multiple databases, because of the hardcoded schema.

Please check that your model does not contain Defining Queries, as schema can be hard-coded in these elements as well.