ORA-00942 with read only account
ORA-00942 with read only account
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?
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 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?
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.
As for the DomainServiceFault class, there should be more information concerning this error, this is a general class just wrapping the communication error.
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.
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.
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.
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:
Code: Select all
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.
Code: Select all
Devart.Data.Oracle.OracleException: ORA-00942: table or view does not exist