Granting the rs_systabgroup System Role

The rs_systabgroup system role owns tables and system procedures that are required for Replication Server, and grants users the underlying system privileges to perform Replication Server functionality.

Prerequisites
MANAGE ROLES system privilege.
Task

You can grant the rs_systabgroup 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 rs_systabgroup system role.

You can grant system privileges and roles to, and revoke them from, the rs_systabgroup system role.

To grant the rs_systabgroup system role, execute:
GRANT ROLE rs_systabgroup TO grantee [,...]
Related reference
GRANT ROLE Statement