The maintenance user is a valid Oracle user that the Replication Server uses to apply commands to the standby Oracle database.
The maintenance user should not be the same as the DCO
Admin Account Name used in configuring DCO.
To create a maintenance user in Oracle
Using SQLPLUS (in the standby database), enter:
create user maintuser identified by password ;
Grant permissions to the maintenance user, who must have the highest privilege of all users who have data or work that will be replicated:
Grant dba to maintuser
Grant create session to maintuser
To create a DDL user in Oracle
Create a DDL (in the standby database) user in Oracle:
create user DDLuser identified by password;
The value for the ddl_username must
not be the same as the value of the maintenance user defined in
Replication Server for the standby connection.
Grant permissions to the DDL user, who must have privileges to perform DDL activities that can include create user, create, alter, drop procedures, indexes, tables and any DDL command issued on the correct database.
This user ID must have authority in the standby database
to issue ALTER SESSION SET CURRENT_SCHEMA= user for
any user who can create DDL in the primary database.
