locked
SQL User Permission for creating sync schema RRS feed

  • Question

  • Does anybody have an idea what permission level for SQL user is necessary to create sync schema (ex. SPs, triggers, tracking tables etc)?
    Thursday, September 30, 2010 4:16 PM

Answers

  • When you provision SQL Server databases that use SqlSyncProvider, be aware of the following permissions requirements for provisioning:

    • CREATE TABLE permissions to enable creation of the metadata tables: scope_info and scope_config, and the tracking tables that are created for each base table.

    • ALTER TABLE to add triggers to the base tables.

    • CREATE PROCEDURE permissions to create the procedures that Sync Framework requires.

    • SELECT and INSERT permissions for scope_info and scope_config tables.

    • SELECT permissions for base tables.

    Thursday, September 30, 2010 4:24 PM