There are two system roles related to replication: SYS_RUN_REPLICATION_ROLE, and SYS_REPLICATION_ADMIN_ROLE.

The SYS_RUN_REPLICATION_ROLE system role is required for performing replication using the dbremote utility and performing synchronization using the dbmlsync utility. The system privileges granted to SYS_RUN_REPLICATION_ROLE are:

• MONITOR
• BACKUP DATABASE
• DROP CONNECTION
• SELECT ANY TABLE
• SET ANY SYSTEM OPTION
• SET ANY USER DEFINED OPTION

In addition to the statements associated with the privileges above, users with the SYS_RUN_REPLICATION_ROLE system role can execute the following statement:

• SYNCHRONIZE PROFILE statement

The SYS_REPLICATION_ADMIN_ROLE system role is required for performing administrative tasks related to replication such as granting replication roles, managing publications, subscriptions, synchronization users and profiles, managing message types, and setting replication-related options. The system privileges granted to SYS_REPLICATION_ADMIN_ROLE are:

• MANAGE REPLICATION
• SET ANY SYSTEM OPTION
• SET ANY PUBLIC OPTION
• SET ANY USER DEFINED OPTION
• SELECT ANY TABLE
• CREATE ANY PROCEDURE
• DROP ANY PROCEDURE
• MANAGE ANY WEB SERVICE
• CREATE ANY TABLE
• DROP ANY TABLE
• SERVER OPERATOR
• MANAGE ANY USER
• MANAGE ROLES
• MANAGE ANY OBJECT PRIVILEGE

These are the minimum (and irrevocable) privileges required for these two roles, but you can grant additional privileges as well.

In addition to the statements associated with the privileges above, users with the SYS_REPLICATION_ADMIN_ROLE system role can execute the following statements:

• SYNCHRONIZE PROFILE statement
• REMOTE RESET statement
• LOCK FEATURE statement

 See also