Post reply

sp_addsubscriber - What permissions does login need?

  • November 2, 2004 at 1:15 pm

    #163059

    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

  • November 5, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • November 5, 2004 at 11:43 am

    #529138

    Hi Dave

    I'm not totally sure but you need at least db_ddladmin, db_datareader and db_datawriter. The last two are obvious and ddladmin is needed during initialization because the tables on the subscriber will be dropped and reacreated, at least if you use the default settings.

    I don't see the need for db_securityadmin, since replication doesn't change any permissions on objects.

    M

    [font="Verdana"]Markus Bohse[/font]

  • November 8, 2004 at 5:57 am

    #529244

    First you need to grant the login acces to the publication, check sp_grant_publication_access in BOL.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply