REVOKE ROLE SYS_REPLICATION_ADMIN_ROLE
FROM grantee[, ...]

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Automatic commit.

• Roles
• GRANT ROLE SYS_REPLICATION_ADMIN_ROLE statement [MobiLink] [SQL Remote]
• REVOKE PUBLISH statement [SQL Remote]
• REVOKE REMOTE statement [SQL Remote]
• REVOKE CONSOLIDATE statement [SQL Remote]
• Synchronization initiation

The following statement revokes SYS_REPLICATION_ADMIN_ROLE from user Sam_Singer.

REVOKE ROLE SYS_REPLICATION_ADMIN_ROLE FROM Sam_Singer;