Granting SYS_REPLICATION_ADMIN

This role is required for performing administration tasks 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

Requires the MANAGE ROLES system privilege.

Task

The SYS_REPLICATION_ADMIN_ROLE 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

This default set of system privileges granted cannot be revoked from the role. However, unlike other system roles, additional system privileges and roles can be granted and revoked from this role.

The WITH ADMIN OPTION or WITH ADMIN ONLY OPTION clauses are not valid when granting the SYS_REPLICATION_ADMIN_ROLE system role.

To grant the SYS_REPLICATION_ADMIN_ROLE system role, execute:

GRANT ROLE SYS_REPLICATION_ADMIN_ROLE TO grantee [,...]

Granting SYS_REPLICATION_ADMIN_ROLE