Replication Agent Permissions and Roles

create table – required to create tables in the primary database.

create trigger – required to create DDL triggers in the primary database.

create procedure – required to create procedures in the primary database.

db_owner – required to allow Replication Agent to execute sp_repltrans and sp_repldone in the primary database. This role is also required for primary database initialization.

sysadmin – required for Microsoft SQL Server data server initialization and deinitialization (using ra_admin init and ra_admin deinit, respectively).