You must have the minimum permission required to execute each RCL command.
If you have create object permission, you automatically have primary subscribe permission. If you have sa permission, you can execute any command.
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 |