Show TOC

grantLocate this document in the navigation structure

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
  • The “sa” permission cannot be revoked from the “sa” user.

  • The “connect source” permission is needed by the RSI or RepAgent. Refer to the Replication Server installation and configuration guides for your platform for more information.

  • For each RCL command described in this manual, the minimum permission required to execute the command is shown. For a list of minimum permissions for all commands, see the Replication Server Administration Guide Volume 1.

  • The users who are not granted any permissions can only monitor Replication Server activities.

Permissions

grant requires “sa” permission.