What permissions needed to add an index with a protected version?

Question

Using arcpy and ArcGIS 10.1 SP1 (Build 3143) against an Oracle 11g enterprise geodatabase, I am trying to add an index to an existing attribute in an existing feature class:

arcpy.AddIndex_management(feature_class,attribute_name,idx_name)

Running as the table owner:

arcgisscripting.ExecuteError: ERROR 999999: Error executing function. Operation only allowed by the owner of the version [SDE.DEFAULT] Failed to execute (AddIndex).

The default version is Protected.

Running as SDE:

arcgisscripting.ExecuteError: ERROR 999999: Error executing function. Insufficient permissions Failed to execute (AddIndex).

As the feature class is owned by a different user than the version owner, what permissions are needed to add an index?

In ArcCatalog, the table owner can happily add an index.

As a workaround, is it possible to change the access of the default version via ArcPy?

Answer 1

I ran into this problem also. Data is owned by USER_A. USER_A attempts to add index by script and gets message "Operation only allowed by the owner of the version [SDE.DEFAULT] Failed to execute (AddIndex)", but USER_A is able to add index in ArcCatalog.

When SDE user tries to add index, it gets "Insufficient permissions Failed to execute (AddIndex)"

Work Around: If you can (big if), have the SDE user make the DEFAULT version public. Then, change back to protected after running the index script. Or, have the DBA give the SDE user CREATE ANY INDEX privilege.