Maintenance User Adaptive Server Login Name and Password

Replication Servers log in to Adaptive Server for the RSSD database or a user database using the maintenance user login name. When applying insert, delete, or update primary operations to replicate databases, Replication Server uses the maintenance user login name and password.

Note: Among the permissions granted to the maintenance user is replication_role. If you revoke maintenance user’s replication_role, Replication Server will not replicate truncate table unless the maintenance user has been granted sa_role, owns the table, or is aliased as the database owner.

To change the password for the maintenance user, use the alter connection command.