At times it may be required to change Shareplex schema on target. This solution delves on a simple way to achieve this, in case it is a one way replication. There is a procedure given in Shareplex Administrator Guide Chapter titled “Performing Administrative Operations” section titled “To change the user when a configuration is active“ but that procedure is elaborate and is the only way to go if the schema change is occurring on source. However, changing Shareplex user on target is much simpler, as explained in this solution.
The following procedure can be followed to change Shareplex user on target in a one-way replication: