Use set proxy To Switch Logins

Use set proxy to allow Replication Server commands to be executed on the target data server by the correct user.

When unified_login is enabled, Replication Server always logs in to remote processes as the principal user. Nonetheless, Replication Server commands must be executed on the target data server by the correct user for a particular operation. For example, Replication Server must use the maintenance user login name when applying changes to replicate databases. Replication Server uses the Adaptive Server set proxy command to switch automatically from the login user to the required user.

You can customize the set proxy command with the rs_setproxy function string. rs_setproxy changes the login name in a data server. rs_setproxy has function-string-class scope.

See Replication Server Reference Manual > Replication Server System Functions > rs_setproxy and Replication Server Reference Manual > Replication Server Commands > set proxy.