Replication Agent for Microsoft SQL Server must create database objects to assist with replication tasks in the primary database.
The following permissions must be granted to the user specified by the pds_username parameter:
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
The user specified by the pds_username parameter must be added to the following roles 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 pdb_xlog init and pdb_xlog remove, respectively).
