The maintenance user is a valid Oracle user that the Rep Server uses to apply commands to the standby Oracle database. It should not be the same name as the “DCO admin account name” used in configuring DCO.
To create a maintenance user in Oracle
Using SQLPLUS, enter the following command:
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 user in Oracle, enter the following command:
create DDLuser identified by password;
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.
