Maintenance User Purpose

The maintenance user inserts, deletes, and updates rows in replicated tables, and executes replicated stored procedures. The database owner (or system administrator) must grant the permission required for the maintenance user to perform these tasks.

To update replicated data, Replication Server logs in to the replicate data server as the maintenance user. In an Adaptive Server replicate database, Sybase Central or rs_init automatically creates the user ID for the Replication Server maintenance user and adds the user to the replicate database.

The maintenance user ID and password are defined to Replication Server automatically with the Replication Server create connection command for the replicate database. If you change the password for the maintenance user ID in the data server, you can use Sybase Central or the Replication Server alter connection command to change the password for the Replication Server connection.

The Replication Server maintenance user must also have permission to access the rs_lastcommit and rs_info system tables in the replicate database, and any stored procedures that use those tables.

Neither Sybase Central nor rs_init grants database permissions to the maintenance user for user tables and stored procedures. You must grant database permissions on replicated tables and stored procedures before you can replicate transactions for replicated tables or replicate executions of the replicated stored procedures. For each table replicated in the database, and for each stored procedure executed due to replication run:

grant all on table_name to maint_user

Alternatively, you can assign the maintenance user ID (maint_user) to a database administrator role, if that role has the required authority on all replicate objects.