ORA-00942

[GMF_TimB]

Hello -

We have created an Oracle DB user/schema (SPARX) that owns the EA tables.  This schema has full control of the tables.  This amount of access is more than we feel confortable sharing in a team environment lest someone accidentally (or purposefully) delets the project from the database.

We have created another user/schema (SPARX_USER) that has INSERT, UPDATE and DELETE access, and we created public synonyms that reflect to the tables controled by the SPARX schema.

When we try to connect to the DB using the SPARX_USER schema, Oracle is throwing ORA-00942 errors which indicate that a table or view isn't available.

I suppose there are two questions:

• Is using Oracle schemas in this way appropriate, or is their a better way to manage access to the Oracle project repository?
• Has anyone seen this error, and can you help with a solution?

Thank you,
Tim B.
GM Financial