The Bentley Map version would be helpful .
So to test this, I guess you have 2 different Oracle users. One had the connect and select roles and the other has the connect, select, update, delete and insert roles,
If you are using the same TNS connection, but with different users, then I see no problem with this.
Some reasons for this error can be:
- Make sure that the TNSNAMES.ORA file exists and is in the correct directory.
- Make sure that the service name that you are connecting to is included in the TNSNAMES.ORA file and that it is correctly defined.
- Make sure that there are no syntax errors in the TNSNAMES.ORA file. For example, if there are unmatched brackets in the file (ie: open bracket without the corresponding close bracket), the file will be rendered unusable.
- Also multiple ORA homes tend to monkey up the works.
Since you do have Oracle spatial installed, are you trying to connect to the database via the Spatial Connection or through the regular database connection method ?? If through the Oralce Spatial method, then the tables need to be spatial tables, with the correct columns, indexes, etc to work correctly. This is explained in the Bentley Map docs.