Minimum Database Permissions Requirements for Microsoft Sync Framework

  • Article

SyncLogo.jpg

Sync Framework Technical Article

Writer: John Mulhausen

Technical Reviewer: Dong Cao

Published: October 2009

Applies to: Microsoft Sync Framework (All Versions)

Summary:  This paper describes the minimum permissions requirements for various synchronization operations using Microsoft Sync Framework with SQL Server products.

Introduction

Microsoft® Sync Framework is a data synchronization platform that enables developers to synchronize with any kind of data over any protocol, including SQL Server databases. This article enumerates the permissions needed for provisioning a database for synchronization, and performing sync operations.

Provisioning

To provision a database for synchronization, the client must use credentials that have the following permissions:

  • CREATE TABLE permission on the database being provisioned.
  • CREATE PROCEDURE permission on the database being provisioned.
  • SELECT and ALTER permissions on each user table.
  • If no user tables exist, grant SELECT and ALTER permissions to the user table schema.
  • AUTHORIZATION permission on the schema for all provision tracking tables.

Synchronization

After provisioning, the client must have the following permissions to perform synchronization tasks:

  • EXECUTE permission on the database being synchronized.
  • SELECT and UPDATE permission to the scope_info table.
  • SELECT, INSERT, UPDATE, and DELETE permissions to each table if data table and stored procedures created by Microsoft Sync Framework are not in the same schema.
  • SELECT and DELETE permission to each tracking table.

Conclusion

For more information:

https://msdn.microsoft.com/en-us/library/dd918682(SQL.105).aspx: How to: Provision a Server Database for Collaborative Synchronization

https://msdn.microsoft.com/en-us/library/dd918848(SQL.105).aspx: Synchronizing SQL Server and SQL Server Compact

https://msdn.microsoft.com/sync: Microsoft Sync Framework Developer Center

Did this paper help you? Please give us your feedback. Tell us on a scale of 1 (poor) to 5 (excellent), how would you rate this paper and why would you give it this rating. For example:

  • Are you rating it high due to good examples, excellent screen shots, clear writing, or another reason?
  • Are you rating it low due to poor examples, fuzzy screen shots, or unclear writing?

This feedback will help us improve the quality of white papers we release. Thank you.

Send feedback.