You can use the Merging Changes option to provide an enhanced level of security to your publication. The Merging Changes option ensures that the Merge Agent has the authority to upload data changes to a Publisher. When you specify this option, SQL Server verifies that the Merge Agent logon has the permissions to perform INSERT, UPDATE, and DELETE statements on the publication database.
Setting Merging Changes Option
Using Merging Changes is optional. When you specify Merging Changes, both Merging Changes validation and PAL verification are performed.
If you set the Merging Changes option after the initial snapshot has been generated, a new snapshot must be generated and reapplied at the Subscriber for permissions to be validated when data changes are merged. |
To configure the Merging Changes option in SQL Server 2005 and later versions, see How to: Set the Merging Changes or Check Permissions Option.
If you specify Merging Changes or Check Permissions, you must grant database access based on how you configured Microsoft Internet Information Services (IIS) and SQL Server Authentication. For more information, see Granting Access to the Database and Publication.