Replication Agent for Microsoft SQL Server must create database objects to assist with replication tasks in the primary database.
The user ID that the Replication Agent instance uses to log in to the Microsoft SQL Server must have access to the primary database with the following permissions granted:
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 role – 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 role – Required for Microsoft SQL Server data server initialization and deinitialization (using pdb_xlog init and pdb_xlog remove, respectively).
