In C Replicator (CREP), you can give a user the rights to use replication (without giving them administrator access) by granting them the SYS_REPLICATION_ROLE. This role is similar to the SYS_ADMIN_ROLE but gives access only to replication-specific operations.
With the SYS_REPLICATION_ROLE, you can perform the following tasks:
▪ read log data for replication partitions from the SYS_LOG system table, and check the current log position,
▪ load a target database from a source database,
▪ check and resolve potential replication conflicts,
▪ start and stop replication subscriptions.
The SYS_ADMIN_ROLE is required to perform the following tasks:
▪ create, alter, and drop replication partitions so that specify the data sets than can be replicated,
▪ create, alter, and drop replication subscriptions that specify the data that can be replicated and the tables that should receive the data.
The tables on the remote server, are accessed by using the user name and password that is specified in the replication connection definition. That user must be granted either the SYS_ADMIN_ROLE or the SYS_REPLICATION_ROLE. The SYS_REPLICATION_ROLE works at the table level; the access is not restricted to the partition limits that are specified in WHERE conditions.