Oracle Replicate Database Permissions

Replication Server requires a maintenance user ID that you specify using the Replication Server create connection command to apply transactions in a replicate database.

The maintenance user ID must be defined at the Oracle data server and granted authority to apply transactions in the replicate database. The maintenance user ID must have these permissions in the Oracle replicate database:

CREATE TABLE authority to create tables used for Replication Server processing.
UPDATE authority on all replicate tables.
EXECUTE authority on all replicate stored procedures.