Editing and ArcGIS Spatial Data Server
You set the properties of a service when you publish it. There are specific properties you can set to use the ArcGIS Spatial Data Server to edit features in a database through a feature service. When publishing the service, choose ArcGIS Spatial Data Server as the Type of Server from the General tab of the Service Editor and choose Feature Access from the Capabilities tab.
On the Feature Services window, specify what sort of access you want connecting users to have. Possible privileges are as follows:
- Create: If you check this option, connecting users with sufficient permissions in the database can create new features.
- Update: This option lets users, who have sufficient permissions in the database, alter existing features.
- Delete: If this option is checked, users with sufficient database permissions can delete features from the feature classes in the service.
- Query: This option lets users select and view features.
All privileges are granted by default. Uncheck any privileges you do not want users to have.
Note:Data in a geodatabase can only be queried when published to a spatial data server. Currently, data using the SQL Server geography type in a database can only be queried. In these cases, uncheck Create, Update, and Delete before publishing.
Who can edit data?
You must be granted privileges to edit the feature classes in a feature service. Those privileges can be granted by the data owner through the ArcGIS for Desktop Privileges dialog box. The feature class privileges required for each type of feature service access are as follows:
Feature service privilege | Feature class privilege required |
|---|---|
Create | Insert |
Update | Update |
Delete | Delete |
Query | Select |
See Granting and revoking privileges on datasets for more information.
Configuring multiple tiers of access
If you need to support multiple tiers of users, each requiring different operations, the recommended approach is to create one service for each level of user. For example, you could create a Professors service that might have all operations allowed. Along with that, you could create a less-privileged Students service with only Create, Query, and Upload operations allowed.
What data can be edited?
You can edit simple, two-dimensional vector data and its attributes in any database management system supported by ArcGIS Spatial Data Server, provided the table you want to edit contains an identifier field that the database populates with unique integer values.
To edit database views through a feature service, the view must be created in accordance with the requirements specified by your database management system (DBMS) for editable views. See your DBMS documentation for information on creating editable views.
What data cannot be edited?
You cannot edit the following through a feature service published to a spatial data server:
- Data that is in a geodatabase
- Data that is enabled for three-dimensions or measures
- Raster data
- Geography data in SQL Server
- Data in tables that do not have a qualifiying identifier field