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

By default, the rs_systabgroup system role is granted the MANAGE PROFILING system privilege with administrative rights only.

It is also 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 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 SYS_RUN_REPLICATION_ADMIN_ROLE system role can be granted to other roles with no administrative rights only (WITH NO ADMIN OPTION clause). The WITH ADMIN OPTION and WITH ADMIN ONLY OPTION clauses are not valid for this role.

To grant the SYS_REPLICATION_ADMIN_ROLE system role, execute:

GRANT ROLE SYS_REPLICATION_ADMIN_ROLE TO grantee [,...]

Granting SYS_REPLICATION_ADMIN_ROLE