Replication Agent requires client access to the primary database to:
Get information about the database schema
Create, manage, and read its transaction log objects (Replication Agents for UDB and Microsoft SQL Server)
Get information about database log devices (Replication Agent for Oracle)
Use the following procedure to set up a user login name in the primary data server and the primary database for the Replication Agent instance.
You must have a System Administrator user role in the
primary data server to perform this procedure.
To create a primary database user login for Replication Agent
Log in to the primary data server with a System Administrator user role.
Add the Replication Agent login name to the primary data server, and if necessary, to the primary database.
Refer to the Sybase Replication Agent Primary Database Guide for information about the permissions and authorities required in each type of primary data server and primary database.
Refer to the documentation provided by your primary data server vendor for information about the specific commands you need to execute to create the Replication Agent login name in the primary data server (and, if necessary, in the primary database).
After you set up the Replication Agent user login in the primary data server, verify that the new user login name is valid (it can log in to the primary data server and access the primary database).
