AnsweredAssumed Answered

How to keep connection to Oracle DB working from ArcGIS Pro 2.0 to 2.2.0?

Question asked by christopheandrey on Aug 29, 2018
Latest reply on Oct 2, 2018 by Evan.Marshall@ci.stpaul.mn.us_stpaul

Hello
I just switched from ArcGIS Pro 2.0 to 2.2.0. 

I have an Oracle 12 DB with 4 schemas, i.e. 4 DB-users. 

With ArcGIS Pro 2.0, I could connect to all four without problem, using TNS names. 

With ArcGIS Pro 2.2.0, I can connect to 3 of them but not to the 4th one. Trying to connect with the 4th user provokes an ORA-933 error. Please note that the 4th user only allows limited SQL-statements (no DDL, just DML, and only read-only ones). 

 

What changed with 2.2.0 in respect to DB connection?

How am I supposed to connect to the DB with 2.2.0 using a DB-user with somewhat restricted rights?

Outcomes