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.
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. |