SDE 10.5.1 Permissions Issue

Discussion created by mvolz47 on Aug 16, 2017
Latest reply on Nov 14, 2017 by ND-GISHUB

My organization is upgrading from ArcGIS 10.3.1 to 10.5.1 where our SDE data is also being migrated from an Oracle11g to Oracle 12c database.  The SDE Administrator needed to update an SDE feature class where the database needed to be compressed to state 0 and then a truncate and append needed to be performed on the SDE feature class as it's update procedure.  This procedure failed with insuffucient permissions for the schema owner in Desktop 10.5.1, but this procedure worked as the schema owner in Desktop 10.3.1.  As such it appears that there is a permissions issue when working with a 10.5.1 Oracle 12c database when using a 10.5.1 Desktop client.


Has anyone else encountered a similar permissions issue with SDE when working with 10.5.1?