Replication system administrators manage Replication Server permissions with the grant and revoke commands. Permissions determine which RCL commands users are permitted to execute.
Any user with a Replication Server login name can execute all admin commands and the check subscription command. Other commands can be executed only by users who have been granted the required permissions.
Replication Server users can be granted any of four permissions.
Permission |
Description |
|---|---|
sa |
Users with sa permission are Replication System Administrators. They can execute any Replication Server command and may grant and revoke other permissions, including sa, to and from other users. |
create object |
Users with create object permission can create objects such as replication definitions, subscriptions, and function strings. Users with create object permission automatically have primary subscribe permission. |
primary subscribe |
Users with primary subscribe permission can execute the commands needed to create subscriptions for primary data stored in databases managed by the Replication Server. Users with primary subscribe permission at the primary site and create object permission at the replicate site can create a subscription for data at the primary site, but cannot create replication definitions or function strings at the primary site. |
connect source |
The connect source permission is required for:
|
