ArcGIS Desktop 10.1 (Build 3143)
ArcSDE 10.0 SP5
Oracle 11.2.0.2
A feature class in our Oracle-SDE database has a subtype field based on a short integer field. If a user, without editing or data ownership privileges, connects to the database they can remove these subtypes if they run the 'Remove Subtype' GP tool. However, if they try to remove a subtype from the feature class properties dialog, they are unable to do so as the apply button is greyed out.
This appears to be inconsistent behaviour, or are we missing an important difference in how this particular GP has been designed? We thought that only the data owner was able to add/remove subtypes to a feature class stored in SDE.
This issue has been identified by esri Inc. as a bug. No information yet as to when this will be fixed.
BUG-000092971
Synopsis: "Remove Subtype" Geoprocessing tool allows non data owner (Viewer) to remove subtypes from a feature class