Setting up the ERSSD user login for Replication Agent

Use the following procedure to set up a user login name for the Replication Agent instance in an ERSSD managed by SQL Anywhere™.

You must have the primary user role in the ERSSD (“sa” permission in the Replication Server) to perform this procedure. See “Setting up the RSSD user login for Replication Agent”.

StepsSetting up the ERSSD user login for Replication Agent

  1. Log in to the ERSSD as the primary user.

  2. Add the Replication Agent login name to the ERSSD:

    grant connect to ra_rssd_user
    identified by ra_rssd_pwd
    

    where:

    • ra_rssd_user is the Replication Agent user login name.

    • ra_rssd_pwd is the password for the user login name.

  3. Give the Replication Agent user permission to read the Replication Server system tables:

    grant membership in group rs_systabgroup
    to ra_rssd_user
    

    Here, 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).