Mirror Replication Agent uses the pds_username to connect to Oracle and must have the following Oracle permissions:
create session – required to connect to Oracle.
select_catalog_role – required to select from the DBA_* views.
alter system – required to perform redo log archive operations.
execute on DBMS_FLASHBACK – required to execute DBMS_FLASHBACK.get_system_change_number.
alter any procedure – required to instrument procedures for replication.
create table – required to create tables in the primary database.
create procedure – required to create rs_marker and rs_dump proc procedures.
create public synonym – required to create synonyms for created tables in the primary database.
create sequence – required to create a sequence.
drop public synonym – required to drop created synonyms.
drop sequence – required to drop a sequence.
select on SYS.OBJ$ – required to process procedure DDL commands.
select on SYS.LOB$ – required to support LOB replication.
select on SYS.COLLECTION$ – required to support table replication.
select on SYS.COL$ – required to support table replication.
select on SYS.CON$ – required to support table replication.
select on SYS.COLTYPE$ – required to support table replication.
select on SYS.CDEF$ – required to support table replication.
select on SYS.USER$ – required to support all replication.
select on SYS.SEQ$ – required to support sequence replication.
In addition, the user who starts the Mirror Replication Agent instance must have read access to the Oracle redo logs.
