Using set proxy to switch logins

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.

Refer to the Replication Server Reference Manual for more information about rs_setproxy.