Permissions

The grant and revoke commands are used to grant and revoke Replication Server permissions for clients. Table 1-1 lists the permissions that can be granted to clients.

Table 1-1: Replication Server permissions

Permission

Capabilities

sa

Gives recipient System Administrator capabilities. Clients with sa permission can perform any Replication Server command.

create object

Allows recipient to create, alter, or drop Replication Server objects, including replication definitions and subscriptions.

primary subscribe

Gives the recipient permission to create a subscription in a primary database, but not to create other objects. To create a subscription at a remote site, a client needs create object permission in the replicate database and create object or primary subscribe permission in the primary database.

connect source

This permission is required for login names used by the Replication Agent. It allows the recipient to execute the RCL commands that are reserved for Replication Agents.