rs_setproxy

Changes the login name in a data server.

Usage

  • 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.

Related reference
alter function string
create function string