Set up a user login name for the Replication Agent instance in an ERSSD managed by
SQL Anywhere®.
Prerequisites
You must have the primary user role in the ERSSD (“sa” permission
in the Replication Server) to perform this procedure.
Task
By default, the Replication Server uses an embedded RSSD.
- Log in to the ERSSD as the primary user.
- Add the Replication Agent login name to the ERSSD:
grant connect to ra_rssd_user
identified by ra_rssd_pwd
where:
- Give the Replication Agent user permission to read the
Replication Server system tables:
grant membership in group rs_systabgroup
to ra_rssd_user
where
ra_rssd_user is
the Replication Agent user login name.
After you set up the 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).