sql server replication: Privilege needed for Merge replication -- sql server replication

Privilege needed for Merge replication

Jay S.
8/27/2007 7:48:04 AM

sql server replication:

Hi,

In order for merge replication to be setup I have created a SQL login on
both the publisher and subscriber and granted it System admin, Process admin
and Bulk Insert admin based on an article I read.

Question is it necessary to grant these server roles at the subscriber and
publisher?
In order to initially set up replication I believe we need these roles but
are this roles necessary once merge replication is setup and running fine?

Thanks,

Re: Privilege needed for Merge replication

Hilary Cotter
8/27/2007 11:03:02 PM

This depends. For push it should be in the dbo_role on the publisher and
subscriber. For pull it should be in the PAL in the publication database.

To create the publication is should be in the sysadmin group or the dbo_role
on the publisher.
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]