Select to view content in your preferred language

Permissions for Create Spatial Type

4179
4
Jump to solution
03-16-2015 11:14 AM
JimO_Leary3
Deactivated User

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

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
BrunoMendes
Deactivated User

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.

View solution in original post

0 Kudos
4 Replies
BrunoMendes
Deactivated User

Hi Jim,

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

0 Kudos
JimO_Leary1
Deactivated User

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.

0 Kudos
BrunoMendes
Deactivated User

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.

0 Kudos
JimO_Leary3
Deactivated User

You are correct, Bruno, thanks.

0 Kudos