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:
In addition to the statements associated with the privileges above, users with the SYS_RUN_REPLICATION_ROLE system role can execute the following 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:
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:
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|