Granting the SYS_REPLICATION_ADMIN

The SYS_RUN_REPLICATION_ADMIN_ROLE system role is required for performing administration tasks that are related to replication, such as granting replication roles, managing publications, subscriptions, synchronization users and profiles, managing message types, setting replication-related options, and so on.

Prerequisites

MANAGE ROLES system privilege.

Task

By default, the SYS_REPLICATION_ADMIN_ROLE system role is granted these system privileges with no administrative rights:

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

You cannot revoke this default set of system privileges from the SYS_RUN_REPLICATION_ADMIN_ROLE system role, but you can grant additional system privileges and roles to, and revoke them from, the SYS_RUN_REPLICATION_ADMIN_ROLE system role.

You can grant the SYS_RUN_REPLICATION_ADMIN_ROLE system role to other roles only with no administrative rights (WITH NO ADMIN OPTION clause). The WITH ADMIN OPTION and WITH ADMIN ONLY OPTION clauses are invalid for the SYS_RUN_REPLICATION_ADMIN_ROLE system role.

To grant the SYS_REPLICATION_ADMIN_ROLE system role, execute:

GRANT ROLE SYS_REPLICATION_ADMIN_ROLE TO grantee [,...]

Granting the SYS_REPLICATION_ADMIN_ROLE