sql server replication: Mege Replication Permission -- sql server replication

Mege Replication Permission

Brian
1/30/2004 7:42:12 AM

sql server replication: I am trying to synchronize a pull subscription via diap-up
where the logged in user is not a member of sys admin or
db_owner. I get an error saying that the user must be a
member of these roles. How can I override this.
Basically, I want to give everyone in the Public role
permission to replicate.

I referred to the books-online topic titled 'Replication
Permissions Checking Constants' but I did not fully
understand what to do with what I read.

Thanks in advance,

Re: Mege Replication Permission

Hilary Cotter
1/31/2004 8:38:50 AM

The user must be a member of at least the dbo on the subscriber and be in
the pal of the publisher.

Anytime you do any replication, the distribution/merge agent has to create
metadata tables (and sometimes user objects) on the subscriber, whether its
push, pull, nosync, sync. You need to be in the dbo role for this.

[quoted text, click to view]