When you install Replication Server, the rs_init program creates the primary and maintenance Adaptive Server login names to maintain the RSSD.
Replication Server uses the primary user login name to modify the system tables in the RSSD for the primary Replication Server. Modifications may include route, replication definition, and function-string information changes to be replicated to RSSDs for other Replication Servers. You set up the primary user when you create the primary RSSD using rs_init.
Replication Server uses the maintenance user login name to apply modifications to replicate RSSDs. RepAgent filters out RSSD modifications made by the maintenance user to avoid replicating them to other RSSDs. You set up the maintenance user when you create the replicate RSSD using rs_init.
If the login name or password is changed for either the primary or maintenance user, edit the Replication Server configuration file to match these changes, and restart the Replication Server.
Observe these guidelines when you change the RSSD primary user login name and password. Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for command syntax details.
Never change the RSSD primary user login name and/or password while routes are being created.
While a route is being created, the destination Replication Server uses the primary user login name and password to create and materialize subscriptions at the destination site for replicated RSSD system tables.
Be sure to also apply the same RSSD primary user login name and/or password changes to the Replication Server.
To change an encrypted or clear text password, use alter user with the set password clause.
To change both a login name and password (encrypted or clear text), use drop user to drop the old login name and create user to create the new login name and password. Then grant the user primary subscribe permission.
See “Managing Replication Server permissions” for more information.
Update the Replication Server configuration file with the new login name and/or password. Use rs_init if the password is encrypted.
For the updates to take effect, restart the Replication Server.
