Changes the login name in a data server.
rs_setproxy has function-string-class scope.
Replication Server creates an rs_setproxy function string for the rs_sqlserver_function_class function-string class during installation. The default value is:
set session authorization “?rs_destination_user!sys”
The generated string has the syntax of the Adaptive Server set proxy command. Use alter function string to replace the default function string.
If a data server does not support network security services or does not have a corresponding set proxy command, you can either turn unified_login to “not required” or create an empty rs_setproxy function string.
Function-string variable modifiers sys contains the login name of a data server. This login name is usually that of the maintenance user or the subscription user.