laptop and a wrench

Bug

Execute permissions are not granted to the PUBLIC user for ST functions when using Oracle 9.2.0.7.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM043870
SubmittedApril 1, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3
Operating SystemWindows OS
Operating System VersionXP
StatusNon-Reproducible

Additional Information

No Public Explanation

Workaround

Granting execute on these 3 types to public allows the SQL to run successfully.STGEOM_AGGR_CONVEXHULLSTGEOM_AGGR_INTERSETIONSTGEOM_AGGR_UNIONAs SDE:GRANT EXECUTE ON SDE.STGEOM_AGGR_CONVEXHULL TO PUBLIC WITH GRANT OPTION;GRANT EXECUTE ON SDE.STGEOM_AGGR_INTERSECTION TO PUBLIC WITH GRANT OPTION;GRANT EXECUTE ON SDE.STGEOM_AGGR_UNION TO PUBLIC WITH GRANT OPTION;

Steps to Reproduce

Bug ID: NIM043870

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options