Replication Agent Permissions

Replication Agent for Oracle uses the pds_username command to connect to Oracle. You must grant the Oracle permissions that are currently identified in the Replication Agent 15.7.1 SP100 Primary Database Guide, as well as these new additions.

GRANT SELECT ON SYS.PARTOBJ$ – required to support partitioned table replication.
GRANT SELECT ON SYS.ICOLS$ – required to support the use of a unique index on columns as the primary key of the replication definition when there is no primary key defined for that table.

See the Replication Agent 15.7.1 SP100 Primary Database Guide > Replication Agent Permissions.

ra_admin_owner User Permissions
For Oracle 10g and 11g, if you configure the ra_admin_owner user, you must also grant the appropriate permissions.

Parent topic: Enhancements in Replication Agent for Oracle