Creating a maintenance user for replication

This section explains how to create a maintenance user in Oracle.

The maintenance user is a valid Oracle user that the Replication Server uses to apply commands to the replicate Oracle database. Replication Server requires one maintenance user to be defined for each connection. Do not use the same name as the DCO Admin Account Name used in configuring the DirectConnect server.

1. Using SQLPLUS, connect to the replicate database and enter:

   create user maintuser identified by password;
   

2. Grant dba and create session permissions to the maintenance user, who must have permission to issue SQL commands against any table to be replicated:

   grant dba to maintuser;
   

   grant create session to maintuser;