Permission summary

Table 8-5 lists the minimum permission required to execute each RCL command. Users with create object permission automatically have primary subscribe permission. Users with sa permission can execute any command.

Table 8-5: Minimum permissions to execute RCL commands

To execute

Minimum permission required

abort switch

sa

activate subscription

create object at replicate, primary subscribe at primary

create partition

sa

admin commands

Can be executed by any user

allow connections

sa

alter connection

sa

alter database replication definition

create object

alter function

create object

alter function replication definition

create object

alter applied function replication definition

create object

alter request function replication definition

create object

alter function string

create object

alter function string class

sa

alter logical connection

sa

alter partition

sa

alter queue

sa

alter replication definition

create object

alter route

sa

alter user

sa – Users can change their own passwords by including the verify clause

assign action

sa

check publication

Can be executed by any user

check subscription

Can be executed by any user

configure connection

sa

configure logical connection

sa

configure replication server

sa

configure route

sa

create article

create object

create connection

sa

create database replication definition

create object

create error class

sa

create function

create object

create function replication definition

create object

create applied function replication definition

create object

create request function replication definition

create object

create function string

create object

create function string class

sa

create logical connection

sa

create partition

sa

create publication

create object

create replication definition

create object

create route

sa

create subscription

create object at replicate, primary subscribe at primary

create user

sa

define subscription

create object at replicate, primary subscribe at primary

drop article

create object

drop connection

sa

drop database replication definition

create object

drop error class

sa

drop function

create object

drop function replication definition

create object

drop function string

create object

drop function string class

sa

drop logical connection

sa

drop partition

sa

drop publication

create object

drop replication definition

create object

drop route

sa

drop subscription

create object at replicate, primary subscribe at primary

drop user

sa

grant

sa

ignore loss

sa

move primary

sa

rebuild queues

sa

resume connection

sa

resume distributor

sa

resume log transfer

sa

resume queue

sa

resume route

sa

revoke

sa

set proxy

sa

set autocorrection

create object

set log recovery

sa

shutdown

sa

suspend connection

sa

suspend distributor

sa

suspend log transfer

sa

suspend route

sa

switch active

sa

sysadmin commands

sa

validate subscription

create object at replicate, primary subscribe at primary

wait for create standby

sa

wait for switch

sa