According to BOL "Only members of the sysadmin fixed server role or db_owner
fixed database role can execute sp_addpublication."
This implies that the minimum set of permissions should merely be dbo
permissions in the selected databases you wish to replicate.
Your error message seems to indicate that the user will require more rights,
can you give us the complete error message and number?
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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] "Giorgio" <george_Martinho@hotmail.com> wrote in message
news:1156153692.579868.157330@75g2000cwc.googlegroups.com...
> Hi,
>
> I have a database on a SQL Server 2000 that needs to be setup as merge
> replication to another SQL Server 2000 but the other server is from a
> customer so we setup a VPN between our networks and I can login and
> make queries on their server and they can also do the same on our
> server so the VPN setup is ok.
>
> The problem is that they are responsible for setting up and maintaining
> the replication ;-), but I have more than one database on our server
> which I am not happy at all to give them access to.
>
> I did setup a login for the database to be replicated BUT I am getting
> an error that says that the user has no rights to the extended sp
> replica.... on master database. So I would have to give my customer
> admin rights which means he has full access to all databases on our
> server!
>
> So my question is, how can I create a user for a database to allow my
> customer to login to my SQL server and setup the replication BUT also
> he cannot access any other databases?
>
> I would really appreciate some urgent help on this.
>
> Thanks a lot in advance
>
