Grant Permissions

Use the grant command to grant permissions to users.

The ability to grant and revoke permissions is reserved for the replication system administrator. Any user who has been granted sa permission can play the role of replication system administrator, and can transfer the grant and revoke ability to other users by granting them sa permission.

The syntax for the grant command is:

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

The user is the login name of the user to receive the permission. You can grant only one permission at a time.

Permissions are assigned to Replication Server users—not to database users. A Replication Server user who has create object permission can create Replication Server objects that are associated with any database managed by the Replication Server.

In the following example, the replication system administrator grants create object permission to the “thomk” login name:

grant create object to thomk