Manage the Maintenance User

To update replicated data, Replication Server logs in to the data server as the maintenance user. The database owner or the system administrator must grant to the maintenance user the permissions required to insert, delete, and update rows in replicated tables and to execute replicated stored procedures.

Initially, Sybase Central or rs_init creates the login name for the maintenance user and adds the user to the replicate database. For details, refer to the Replication Server installation and configuration guides for your platform.

The maintenance user login name and password are provided to Replication Server with the create connection command for the database. Sybase Central or the rs_init program executes this command automatically. If you change the password for the login name in the data server, use Sybase Central or the alter connection command to change the password for the Replication Server connection.

You cannot use the rs_init utility for non-ASE databases. You must create and manage maintenance user login names in the non-ASE database server. See the Replication Server Heterogeneous Replication Guide for information related to non-ASE servers.

For Adaptive Server databases, you can protect the maintenance user with additional security measures.

• Find the Current Maintenance User
  Use rs_helpuser to determine the login name that is currently assigned as maintenance user for a database.
• Grant Permissions in the Database
  Use Sybase Central or rs_init to grant the maintenance user permission to access the rs_lastcommit system table and the stored procedures that use it. Use grant all to grant permissions for tables and stored procedures involved in replication.