Show TOC

revokeLocate this document in the navigation structure

Revokes permissions from users.

Syntax
revoke {sa | connect source | create object |
 primary subscribe}
 from <user>
Parameters
sa

Denies permission to execute commands that require “sa” permission.

connect source

Denies permission to execute RCL commands used by RepAgents or other Replication Servers.

create object

Denies permission to create, alter, and drop Replication Server objects such as replication definitions, subscriptions, and function strings.

primary subscribe

Denies permission to create subscriptions for a replicated table if the primary data is managed by the current Replication Server.

user

The login name of the user whose permission is to be revoked.

Examples
Example 1

Prevents user “thom” from executing commands that create or modify Replication Server objects:

revoke create object from thom
Example 2

Prevents user “louise” from creating subscriptions for primary data managed by this Replication Server, unless she has “create object” or “sa” permission at the primary Replication Server:

revoke primary subscribe from louise
Usage
  • revoke requires “sa” permission.

  • The “sa” permission cannot be revoked from the “sa” user login name.

Permissions

revoke requires “administrator” permission.