Creating a maintenance user and DDL 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 standby 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 standby 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;
   

1. Create a DDL user in the standby database:

   create user ddl_user identified by password;
   

   The value of the ddl_username parameter must not be the same as the value of the maintenance user defined in Replication Server for the standby connection.

2. Grant permissions to the DDL user, which must have privileges to perform DDL activities and issue any DDL command on the correct database.

   The user ID for the DDL user must have authority in the standby database to issue the ALTER SESSION SET CURRENT_SCHEMA=user command for any user who can create DDL in the primary database.