Replication Servers log in to Adaptive Server for the RSSD database or a user database using the maintenance user login name. When applying primary changes (insert, delete, or update operations) to replicate databases, Replication Server uses the maintenance user login name and password.
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.
