grant

Description

Assigns permissions to users.

Syntax

grant {sa | create object | primary subscribe |
 connect source}
 to user

Parameters

sa

Users with “sa” permission can execute any RCL command.

create object

Allows the recipient to create, alter, and drop Replication Server objects, such as replication definitions, subscriptions, and function strings.

primary subscribe

Allows recipient to create subscriptions for a replicated table whose primary data is managed by the current Replication Server.

connect source

This permission is granted to RepAgents and other Replication Servers to log in to the Replication Server.

user

The login name of a user who is to receive the permission.

Examples

Example 1

Allows the user “thom” to execute any Replication Server command:

grant sa to thom

Example 2

Allows the user “louise” to create subscriptions:

grant primary subscribe to louise

Usage

Permissions

grant requires “sa” permission.

See also

revoke