In Esri Enterprise Geodatabase (SQL), is it possible to give Update privileges but not Insert or Delete?

DanielWebb

We sometimes have situations where we want to give Update privileges to someone, but we do not want them able to add or delete features. Like we just want someone to be able to edit fields but not geographic features. But in ArcGIS Pro, when I click ‘Update’ it auto-checks both ‘Insert’ and ‘Delete’. (See screenshots below.)

Is this possible?

On a secondary question, it would be really nice if we could limit Update privileges to specific fields, but that may be too much of an ask. But if anyone knows whether this is possible, I’d like to know that too.

Thanks!

sql-privileges-1.PNG

sql-privileges-2.PNG

Eugene_Adkins

When you publish a feature service you should have the ability to control whether the feature allows new features to be added or deleted or updated from the configuration tab (screenshot below is Pro 3.1.1). Maybe you're using a new version?

By choosing "attributes only" you can prevent the feature from being moved while still allowing fields to be edited.

 To restrict the fields that can be edited there are a few options.

1. When you publish your feature, you can control whether or not the fields are "read only" in the aprx itself with the data design/fields settings. Be mindful if you choose this option for the fields, they will not have the ability to be edited unless you republish the service with this setting turned off.
2. If you use Map Viewer classic, you can set whether or not the specified field can be edited by using the configure pop-up/configure attributes/remove the edit capability option (if the published service is being used in the field).
3. If you use "new" Map Viewer, you can set whether or not the specified field can edited by using the Fields Maps app/content/the "targeted" layer/remove the edit capability option in the smart form itself (if the published service is being used in the field).

There are also some edit settings that can be updated on the server manager side. This might be where you can remove the option(s) for the Feature Access to create or delete while also keeping the option to update without allow geometry updates (i.e. the features can't be moved, only attribute information can be updated):

Hope that helps.