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. Table 4-6 lists the required permissions that are granted.
Permissions |
When required |
---|---|
create table |
To create tables in the primary database. |
create trigger |
To create DDL triggers in the primary database. |
create procedure |
To create procedures in the primary database. |
create role |
To create the "ReplicationAdmin" role. Only the user with the "ReplicationAdmin" role can mark a table or procedure. |
db_owner role |
To allow Replication Agent to execute sp_repltrans and sp_repldone in the primary database. This role is also required for primary database initialization. |
grant |
To grant select permission on sys.sysschobs to the "ReplicationAdmin" role. |
sysadmin role |
For Microsoft SQL Server data server initialization and deinitialization using pdb_xlog init and pdb_xlog remove, respectively. |