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.
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 |
