Write permission is required on data for one-way replica

Last Published: April 25, 2020


Write permission is required when creating a one-way replica.


Currently, a requirement for creating replicas is that the user creating the replica be granted write access on the data.

This should not be a requirement for one-way replicas.


Using ArcCatalog, temporarily grant write access on the data to the user creating the replica and have the user create the replica.

  1. Connect to the database as the data owner.
  2. Right-click on the data that is to be replicated > Privileges.
  3. Type the user's name that is to replicate the data and check SELECT, INSERT, UPDATE, and DELETE.
  4. Click OK to apply these privileges.
  5. Once the replica is created, revoke the write access by right-clicking on the data as the data owner > Privileges > type the user's name > only check SELECT > click OK.

    Synchronization of data changes and schema changes subsequently succeed without the write permission.

Article ID:000010390

  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options