Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2004-11-02 : 15:05:33
|
| When configuring replication, what permissions are needed by SQL Server to connect to a subscriber? I ask because our replication was configured using SA to connect to the subscriber. I would like to limit permissions to what is needed by replication to perform its work and am guessing that dbo or possibly the combination of db_datareader, db_datawriter, db_ddladmin and db_securityadmin would do the job.Thanks, Dave |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-03 : 06:33:51
|
according to bolquote:
You must be a SQL Server 2000 system administrator to enable the server for replication. After replication is enabled, you do not need to be a SQL Server 2000 system administrator to set up publications and subscriptions, or to invoke or schedule the replication agents. You must be in the db_owner role to create publications. Anyone who is added to the publication access list (PAL) can create pull subscriptions to that publication (but only to that publication)....It is recommended that the Subscriber connection have dbo permissions in the subscription database to make sure the proper permissions are granted, and for overall simplification; however, dbo permissions are not required.
--------------------keeping it simple... |
 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2004-11-03 : 09:15:32
|
| Thanks Jen. Not sure how I missed that one in BOL. |
|
|
|
|
|
|
sp_addsubscriber-What permissions does login need?