Address Data Management Solution - "EXECUTE" permissions

[CelinaR]

Hello - we recently deployed the address data management solution to our (11.3) enterprise portal. Our entire enterprise geodatabase is in dbo schema, and I am a dbo - when I attempt to edit the master street name table, I receive an error regarding "EXECUTE" permissions. From what I'm reading, it seems there are at least two fixes for this, one of which is to create an editor role with execute permissions for the addressing dataset, and another is to create a schema specifically for the addressing data and assign the tables, procedures, etc to that schema.

It's been a little challenging to figure out the best route. How are other folks handling this?

[Joshua-Young]

We use the SDE schema for our geodatabase ownership (nothing wrong with DBO), but we create a separate account and schema to load GIS data into. We use branch versioning, so we set that up and use ArcGIS Enterprise's sharing functionality to share the service with those that need to edit.

If you are not using branch versioning, I would create a group to add editors to, and give that group SELECT, INSERT, UPDATE, and DELETE permissions to your addressing dataset.

We have it setup that way for separation of roles, even though most of the time I am the one managing all those roles. It provides better security and helps protect from mistakes. You can do it all under one account and schema which is more convenient to use, but also more convenient to modify and delete things when you do not mean to.