Permissions for Create Spatial Type

[JimO_Leary3]

We would like to create the ST_GEOMETRY data type in Oracle by running the Create Spatial Type in ArcGIS Desktop. The documentation for this tool says that you have to use the SYS account to create the SDE schema, but our policy prevents us using the SYS account on a client machine. We could create another, temporary user for this task. What permissions are necessary for Create Spatial Type?

Thanks

[BrunoMendes]

Hi Jim,

This article explains how to do it in Oracle: Set up a geodatabase in Oracle—Help | ArcGIS for Desktop​.

[JimO_Leary1]

Thanks Bruno. I think this refers to creating a geodatabase, though, not running the Create Spatial Type, which would actually create the ST_GEOMETRY type.

[BrunoMendes · Accepted solution]

Jim, I pointed that link because at the section "Privileges required for geodatabase creation or upgrade" it states a list of permissions needed to create ST_GEOMETRY type.

[JimO_Leary3]

You are correct, Bruno, thanks.