Use the following procedure to set up a user login name for the Mirror Replication Agent instance in an ERSSD managed by Adaptive Server Anywhere.
See “Setting up the RSSD user login for Mirror Replication Agent” for information about setting up a user login name for the Mirror Replication Agent instance in an RSSD managed by Adaptive Server Enterprise.
You must have the primary user role in the ERSSD (“sa” permission
in the Replication Server) to perform this procedure.
To set up the ERSSD user login for Mirror Replication Agent
Log in to the ERSSD as the primary user.
Add the Mirror Replication Agent login name to the ERSSD:
grant connect to mra_rssd_user identified by mra_rssd_pwd
where:
mra_rssd_user is the Mirror Replication Agent user login name.
mra_rssd_pwd is the password for the user login name.
Give the Mirror Replication Agent user permission to read the Replication Server system tables:
grant membership in group rs_systabgroup to mra_rssd_user
where mra_rssd_user is the Mirror Replication Agent user login name.
After you set up the Mirror Replication Agent user login in the ERSSD, verify that the new user login name is valid (it can log in to the ERSSD and access the Replication Server system tables).
