English

Bug: Write permission is required on data for one-way replica

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.