Creating a Primary Database User Login for Replication Agent

Replication Agent requires client access to the primary database to get information about database schema, read and manage Replication Agent objects in the primary database, and get information about database log devices (Replication Agent for Oracle and Replication Agent for Microsoft SQL Server).

To set up a user login name in the primary data server and the primary database for the Replication Agent instance:

Note: You must have a system administrator user role in the primary data server to perform this procedure.

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