BUG

Write permission is required on data for one-way replica

Last Published: April 25, 2020

Description

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

Cause

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.

Workaround

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

Software:
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic